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

Holder

An individual or entity that legally possesses a negotiable instrument, such as a check or a bond, and has the right to collect the value of the instrument.

Payable

Describes an amount of money that is owed and should be paid, often within a specified period.

Bearer

Refers to an individual or entity in possession of a negotiable instrument, such as a check or bond, that is payable to whoever holds it.

Payable

Due for payment; a financial obligation that one party has to pay to another.