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:

Hyperspace

A concept from mathematics and science fiction referring to a space with more dimensions than those of the observable universe.

Simulacrum

An image or representation of someone or something that is not true to the original but is accepted as real.

Surface

The outer or topmost boundary of an object, which can be perceived directly or interacted with.

Jacques Derrida

A French philosopher best known for developing deconstruction, a critical approach that explores the complexities and instabilities in texts, language, and meaning.