Contents of the CUSTOMERS Table​

question 27

Multiple Choice

Contents of the CUSTOMERS table​

-​Based on the contents of the CUSTOMERS table,which of the following SQL statements will display the customer# of all customers who were referred by the same individual that referred customer# 1003?

• A) ​SELECT customer# FROM customers WHERE referred = (SELECT referred FROM customers WHERE customer# = 1003);
• B) ​SELECT customer# FROM customers WHERE referred EXISTS (SELECT referred FROM customers WHERE customer# = 1003);
• C) ​SELECT customer# FROM customers WHERE NVL(referred,0)= (SELECT NVL(referred,0)FROM customers WHERE customer# = 1003);
• D) ​SELECT customer# FROM customers WHERE NVL(referred,0)= (SELECT referred FROM customers WHERE customer# = 1003);

---

Definitions:

Bargaining Power

The relative capacity of parties in a negotiation to exert influence over each other, often influencing the terms and conditions of agreements.

Dominant Firms

Companies that have a major share of the market sales or exert significant influence in their industry.

Contestable Market

A market structure where there are no barriers to entry or exit, and hence, firms face potential competition.

Exceeds Marginal Cost

The condition where the revenue received from the sale of an additional unit of output is greater than the cost required to produce that additional unit.