Contents of the ORDERS Table

question 66

Multiple Choice

Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?​

• A) ​SELECT * FROM orders WHERE shipdate = NULL;
• B) ​SELECT * FROM orders WHERE shipdate > NULL;
• C) ​SELECT * FROM orders WHERE shipdate LIKE 'NULL';
• D) ​none of the above

---

Definitions:

Straight Line

A method of depreciation that allocates an asset’s cost evenly throughout its useful life.

Ice Cream Machine

A device designed to produce ice cream on a commercial or domestic scale by freezing and churning ingredients.

Tax Schedule

A detailed plan or system for calculating tax liabilities based on income, deductions, and credits according to relevant laws and regulations.

Taxable Income

The amount of income used to calculate how much tax an individual or a company owes to the government.