Contents of the ORDERS Table

question 105

Multiple Choice

Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will list all orders placed by customer # 1020 that have not yet been shipped?​

• A) ​SELECT * FROM orders WHERE customer# = 1020 OR shipdate = NULL;
• B) ​SELECT * FROM orders WHERE customer# = 1020 AND shipdate IS NULL;
• C) ​SELECT * FROM orders WHERE customer# = 1020 OR shipdate IS NULL;
• D) ​SELECT * FROM orders WHERE customer# = 1020 AND shipdate = NULL;

---

Definitions:

Drawings

Withdrawal of cash or other assets from an unincorporated business for the personal use of the owner(s).

Authorized Shares

The maximum number of shares that a corporation is legally allowed to issue, as specified in its articles of incorporation.

Market Value

The existing cost for buying or selling an asset or service on the market.

Not-For-Profit

Organizations that operate for purposes other than generating profit, often focusing on social, educational, or charitable endeavors.