Multiple Choice
Which of the following is NOT true regarding outer joins?
A) The OUTER JOIN clause returns all rows from two or more of the tables within the FROM clause,as long as those rows meet any WHERE or HAVING search conditions.
B) The OUTER JOIN clause is used whenever multiple tables that are accessed through a SQL SELECT statement returns all of the records from one table and only those records from the other table where the joined fields match.
C) The LEFT JOIN clause is used when you want to return all rows in the left table,even if no matching rows exist in the right table.
D) The FULL OUTER JOIN clause is not supported in Microsoft Access.
Correct Answer:

Verified
Correct Answer:
Verified
Q89: Match the following terms to their definition:<br>I.Physical
Q90: Which of the following is NOT true
Q91: When working with SQL,if a field includes
Q92: _ is one of the most important
Q93: When working with SQL,if a field includes
Q95: The _ is the easiest way to
Q96: Sum can only be performed on number
Q97: Which of the following is NOT a
Q98: When writing SQL,the _ selects and returns
Q99: The benefit of learning SQL is that