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:

Estate-Planning

The process of organizing and managing an individual's assets for transfer after death, including the creation of wills and trusts.

Long-Term Care

A range of services and supports to meet health or personal care needs over an extended period of time, often for the elderly or disabled.

Elderly Patients

Individuals of advanced age who are receiving medical care or treatment.

Martindale-Hubbell Law Directory

A comprehensive directory providing detailed information about attorneys and law firms around the world, used for professional and consumer legal research.