​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:

Cognitive Restructuring

A psychotherapeutic process of learning to identify and dispute irrational or maladaptive thoughts known as cognitive distortions, a core aspect of cognitive-behavioral therapy.

Thought Record

A cognitive behavioral therapy tool used to capture, evaluate, and challenge negative thought patterns.

Fear Hierarchy

A fear hierarchy is a list of feared situations or objects that are arranged in descending order according to how much they evoke anxiety. This list is then used in therapy for exposure exercises.

Response Prevention

A behavioral treatment technique, particularly used in treating OCD, where the patient is prevented from performing a compulsive behavior.