​ Structure of the ORDERS Table

question 32

Multiple Choice

​
Structure of the ORDERS table
Structure of the CUSTOMERS table
​
-​Which of the following SQL statements will list the name of each customer stored in the CUSTOMERS table,and,if the customer has placed an order that is contained in the ORDERS table,the order# of any order each customer has placed?

• A) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NOT NULL;
• B) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# (+)= customers.customer#;
• C) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# = customers.customer# (+);
• D) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NULL;

---

Definitions:

Fraud

Intentional deception or misrepresentation made for personal gain or to damage another individual.

Documented Records

Official records and documents that have been recorded, collected, and preserved as evidence or information.

Public Survey

A research tool used to collect data from a specific population, typically consisting of standardized questions to gather opinions or behaviors.

No Risk Assessment

The absence of evaluation or analysis of the potential negative impacts or dangers associated with an activity or decision.