Contents of the ORDERS Table

question 21

Multiple Choice

Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will not list the orders that have been shipped to Atlanta or Seattle?​

• A) ​SELECT * FROM orders WHERE shipcity = 'ATLANTA' OR shipcity = 'SEATTLE';
• B) ​SELECT * FROM orders WHERE shipcity IN ( 'ATLANTA' ,'SEATTLE');
• C) ​SELECT * FROM orders WHERE shipcity = 'Atlanta' OR shipcity = 'Seattle';
• D) ​SELECT * FROM orders WHERE shipcity LIKE 'AT%' OR shipcity LIKE 'SEA%';

---

Definitions:

Buyer Receives

In a transaction, when the buyer takes possession or ownership of the purchased goods.

Encumber Goods

To place a burden or charge on goods, such as a lien or mortgage, that affects their use or transferability.

Title To Delivery

A legal concept indicating the transfer of ownership of goods from a seller to a buyer when specific conditions are met.

Small Business Loan

Financing specifically targeted to support the needs and growth of small and medium-sized enterprises, often provided with favorable terms.