Merge Append Quiz

What you'll be asked

1. When you want to combine two datasets by stacking them vertically (adding more rows), which operation should you perform?
2. You have a 'Sales_Jan' table and a 'Sales_Feb' table with identical column structures. What is the most efficient way to create a single 'Q1_Sales' table?
3. If you are merging two tables on a common ID column, but the ID column contains different data types (e.g., text vs. integer) in each table, what is the likely result?
4. What happens if you perform an append operation on two tables that have different column names?
5. You are performing a 'Left Outer Join' between a 'Customers' table and an 'Orders' table. If a customer has placed no orders, how will this row appear in the resulting merged dataset?

Answers and explanations come after you submit.