CET_TARDE - MTA Database - E_Join_Union_Intersect

Question 1 of 5

1

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?

Select one of the following:

INTERSECT
UNION
JOIN
TRUNCATE

Explanation

Question 2 of 5

1

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?

Select one of the following:

TRUNCATE
JOIN
EXCEPT
UNION

Explanation

Question 3 of 5

1

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?

Select one of the following:

Complete join
Partial join
Inner join
Outer join

Explanation

Question 4 of 5

1

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?

Select one of the following:

0
2
3
6

Explanation

Question 5 of 5

1

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:

Select one of the following:

No change is needed
INTERSECT
ALL
UOIN

	Created by Hawerth Castro over 7 years ago

Database Quizzes preparing to certification

CET_TARDE - MTA Database - E_Join_Union_Intersect

Question 1 of 5

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?

Select one of the following:

Explanation

Question 2 of 5

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?

Select one of the following:

Explanation

Question 3 of 5

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?

Select one of the following:

Explanation

Question 4 of 5

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?

Select one of the following:

Explanation

Question 5 of 5

Select one of the following:

Explanation

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?