​Contents of ORDERS Table

question 41

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 number of days between the date an order was placed and the date it was shipped?

• A) SELECT order#,TO_CHAR(shipdate-orderdate,'99')FROM orders WHERE shipdate IS NOT NULL;
• B) SELECT order#,MONTHS_BETWEEN(shipdate-orderdate,'99')FROM orders WHERE shipdate IS NOT NULL;
• C) SELECT order#,ADD_MONTHS(shipdate-orderdate,'99')FROM orders WHERE shipdate IS NOT NULL;
• D) SELECT order#,DAYS_BETWEEN(shipdate-orderdate,'99')FROM orders WHERE shipdate IS NOT NULL;

---

Definitions:

Positive Feedback

A process in which the effects of a small disturbance on a system include an increase in the magnitude of the perturbation.

Feedback

Information given to individuals or groups about their performance, with the aim of improving future performance or understanding.

Achieving Goal

The process of setting, pursuing, and attaining objectives or desired outcomes.

Force-Field Analysis

A technique used to identify, discuss, and evaluate the various forces for and against a proposed change.