Multiple Choice
Structure of the ORDERS table
Structure of the CUSTOMERS table
-Which of the following SQL statements will display all customers who have not recently placed an order?
A) SELECT customer# FROM customers
UNION
SELECT customer# FROM orders;
B) SELECT customer# FROM orders
MINUS
SELECT customer# FROM customers;
C) SELECT customer# FROM orders
INTERSECT
SELECT customer# FROM customers;
D) SELECT customer# FROM customers
MINUS
SELECT customer# FROM orders;
Correct Answer:

Verified
Correct Answer:
Verified
Q31: If you are joining five tables in
Q32: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg" alt=" Structure of
Q33: Tables can be joined in the<u> FROM</u>
Q34: The <u>JOIN...USING</u> keywords are used to join
Q35: The <u>outer join</u> operator is placed on
Q37: The <u>ON </u>clause can be used only
Q38: The _ keyword can be included in
Q39: Which of the following keywords is used
Q40: When combining the results of two SELECT
Q41: The JOIN keyword is used in the