​ 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;

---

Definitions:

Jointly Exhaustive

A condition where all possible outcomes or cases are covered by the set of propositions or options.

Equally Abstract

Pertaining to concepts or ideas that are similarly removed from concrete reality and difficult to define precisely.

Organizing Concepts

Principles or ideas that are used to structure and categorize understanding or knowledge.

Religious Affiliations

The association or connection of an individual or group with a particular religion or belief system.