Merge Append Quiz

Quiz covering Transform and Load the Data

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   When you want to combine two datasets by stacking them vertically (adding more rows), which operation should you perform?

2. 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. 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. 4

   What happens if you perform an append operation on two tables that have different column names?

5. 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?