Solved

Match the Following Terms to Their Definition

Question 101

Matching

Match the following terms to their definition:

Premises:

Responses:

INNER JOIN

Returns only the rows that actually match

OUTER JOIN

Returns all rows from both tables

FULL JOIN

Usually added in the WHERE clause

Union query

Returns all rows from at least one of the tables

SQL subquery

Combines two SQL SELECT statements

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

Related Questions

Q93: A crosstab query is different than the

Q94: The _ is the easiest way to

Q95: Joins are performed based on a(n)_,which specifies

Q96: When writing SQL,the _ selects and returns

Q97: Match the following terms to their definition:
I.INNER

Q98: A(n)_ is a separate SELECT statement that

Q99: Match the following terms to their definition:
I.Physical

Q100: The _ clause is used to return

Q102: Match the following terms to their definition:

Q103: Match the following terms to their definition:

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

Scan the QR code to install the App and get 2 free unlocks

Unlock quizzes for free by uploading documents