Solved

​ Structure of the ORDERS Table

Question 36

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;
Structure of the ORDERS table
  ​ 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; 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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions