Contents of the ORDERS Table

question 105

Multiple Choice

Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will list all orders placed by customer # 1020 that have not yet been shipped?​

• A) ​SELECT * FROM orders WHERE customer# = 1020 OR shipdate = NULL;
• B) ​SELECT * FROM orders WHERE customer# = 1020 AND shipdate IS NULL;
• C) ​SELECT * FROM orders WHERE customer# = 1020 OR shipdate IS NULL;
• D) ​SELECT * FROM orders WHERE customer# = 1020 AND shipdate = NULL;

---

Definitions:

Operating Merger

Occurs when the operations of two companies are integrated with the expectation of obtaining synergistic gains. These may occur due to economies of scale, management efficiency, or a host of other reasons.

Synergy

Occurs when the whole is greater than the sum of its parts. When applied to mergers, a synergistic merger occurs when the postmerger earnings exceed the sum of the separate companies’ pre-merger earnings.

Pro Forma Cash Flows

Projected cash inflows and outflows that are expected to occur as a result of a proposed financial decision or investment.

Hostile Takeover

An acquisition attempt by a company or individual without the consent or cooperation of the target company's board of directors.