CET_TARDE - MTA Database - E_Join_Union_Intersect

You need to retrieve data from two related database tables based on a column that exists in both tables. Which command should you use in a query?

You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?

You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column. The results include: . All customers and their orders . Customers who have no orders Which type of join do these results represent?

You have two tables named Cars and Color as defined below. The two tables are related by ColorId. How many rows does the SQL statement return?

This question requires that you evaluate the underlined text to determine if it is correct. The UNION keyword combines the results of two queries and returns only rows that appear in both result sets. Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct: