​Contents of ORDERS Table

question 76

Multiple Choice

​Contents of ORDERS table
Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
-​Based upon the contents of the ORDERS table,which of the following SQL statements will display the ship date for order 1006 as April 2,2002?

• A) ​SELECT order#,TO_CHAR(shipdate,'Month DD,YYYY') FROM orders;
• B) ​SELECT order#,TO_DATE(shipdate,'Month DD,YYYY') FROM orders;
• C) SELECT order#,TO_CHAR(shipdate,'Month DY,YYYY') FROM orders;
• D) SELECT order#,TO_DATE(shipdate,'Month DY,YYYY') FROM orders;

---

Definitions:

Rib Cage

The set of bones around the chest that protects the heart, lungs, and other organs within the thorax.

Lordosis

The inward curvature of a portion of the lumbar and cervical vertebral column, which can become exaggerated in certain medical conditions.

High Heels

Shoes with raised heels which elevate the wearer's feet significantly higher than their toes.

NSAIDs

Nonsteroidal anti-inflammatory drugs, a class of medications that reduce pain, decrease fever, prevent blood clots, and in higher doses, decrease inflammation.