​Contents of ORDERS Table

question 53

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 only those orders shipped to the zip code zone that begins with 323?

• A) SELECT order#,SUBSTR(shipzip,1,323) FROM orders;
• B) SELECT order#,SUBSTR(shipzip,1,323) FROM orders WHERE shipzip = 323;
• C) SELECT order# FROM orders WHERE shipzip = SUBSTR(shipzip,1,323);
• D) SELECT order# FROM orders WHERE SUBSTR(shipzip,1,3)= 323;

---

Definitions:

Fixations

An obsessive interest or feeling towards a particular object or subject.

Reader

An individual who reads or an electronic device designed for reading texts, such as an e-book reader.

Text

Written or printed words regarded as forming a piece of literature, document, or other pieces of written material.

Morphemes

are the smallest grammatical units in a language that carry meaning, such as prefixes, suffixes, and root words.