​ Structure of the ORDERS Table

question 85

Multiple Choice

​
Structure of the ORDERS table
Structure of the CUSTOMERS table
​
-​Which of the following SQL statements will return the names of all customers who placed an order on April 12,2003?

• A) SELECT lastname,firstname FROM customers WHERE orderdate = '12-APR-03';
• B) SELECT lastname,firstname FROM customers NATURAL JOIN orders WHERE orderdate = '12-APR-03';
• C) SELECT lastname,firstname FROM customers JOIN orders ON (customer#) WHERE orderdate = '12-APR-03';
• D) ​both a and b

---

Definitions:

Lease

A contractual agreement where one party, the lessor, grants the other party, the lessee, the right to use a property or asset for a specified period in exchange for rental payments.

Preference Shares

Shares of a company's stock with dividends that are paid out to shareholders before common stock dividends are issued.

Common Shares

Equity securities that represent ownership in a corporation, providing voting rights and a share in the company's profits through dividends.

Doctrine of Ultra Vires

A legal principle stating that acts done beyond the scope of power of a corporation or governmental entity are invalid or void.