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

Condition Subsequent

A condition in a contract that, if it occurs, can end the contract or modify its terms after the contract has been executed.

Sale Or Return

A commercial arrangement where goods are provided to a buyer or reseller who has the option to return unsold items within a specified period instead of purchasing them.

Accord And Satisfaction

A legal agreement between parties to settle a dispute by agreeing on a payment that is different from the original obligation.

Novation

The process of replacing an obligation to perform with a new obligation or substituting a new party to an agreement.