Matching
Match the following terms to their definition:
Premises:
INNER JOIN
OUTER JOIN
FULL JOIN
Union query
SQL subquery
Responses:
Returns only the rows that actually match
Returns all rows from both tables
Usually added in the WHERE clause
Returns all rows from at least one of the tables
Combines two SQL SELECT statements
Correct Answer:
Premises:
Responses:
INNER JOIN
OUTER JOIN
FULL JOIN
Union query
SQL subquery
Premises:
INNER JOIN
OUTER JOIN
FULL JOIN
Union query
SQL subquery
Responses:
Related Questions
Q72: Sales volume is the number of items
Q73: The SQL _ clause specifies which table
Q74: A(n)_ is used to query unrelated tables
Q75: The OUTER JOIN clause is used to
Q76: Another way a(n)_ clause can be used
Q78: A crosstab query is different than the
Q79: _ is the number of items sold
Q80: Match the following terms to their definition:
Q81: Which of the following is NOT true
Q82: The WHERE clause,which is optional in a