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.


A

Computer Science & Information Technology

You might also like to view...

Once the access mechanism is positioned, the time required for the data to rotate to the read/write head is called __________.

a. rotational delay b. lag time c. access time d. seek time

Computer Science & Information Technology

The correct statement to use to pop an element from a stack (implemented as a linked list) is _____________ .

a. head = head->link; b. head = NULL; c. last = head; d. last->link = new; e. head->link = new;

Computer Science & Information Technology

What task can't be performed from the IE General tab?

A. change the home page B. disable file downloads C. delete browsing history D. manage the IE cache

Computer Science & Information Technology

The bottom half of the window in a query's design view is the Query ________

Fill in the blank(s) with correct word

Computer Science & Information Technology