Which of the Following SQL Statements Is a Correctly Stated

question 92

Multiple Choice

Which of the following SQL statements is a correctly stated correlated subquery?

• A)SELECT C1.CustName,C1.SalesRepNo
• FROM CUSTOMER C1
• WHERE C1.SalesRepNo IN
• (SELECT S1.SaleRepNo
• FROM SALESREP S1
• WHERE S1.RepName = 'Smith');
• B)SELECT C1.CustName,C1.SalesRepNo
• FROM CUSTOMER C1
• WHERE C1.SalesRepNo IN
• (SELECT S1.SaleRepNo
• FROM SALESREP S1
• WHERE S1.RepName = 'Smith')
• AND C1.SalesRepNo=S1.SalesRepNo);
• C)SELECT C1.CustName,C1.SalesRepNo
• FROM CUSTOMER C1
• WHERE C1.SalesRepNo IN
• (SELECT S1.SaleRepNo
• FROM SALESREP S1
• WHERE S1.RepName = 'Smith')
• AND C1.SalesRepNo<>S1.SalesRepNo);
• D)SELECT C1.CustName,C1.SalesRepNo
• FROM CUSTOMER C1
• WHERE C1.SalesRepNo IN
• (SELECT C2.SaleRepNo
• FROM CUSTOMER C2
• WHERE C1.SalesRepNo=C2.SalesRepNo);
• AND C1.OrderNo<>C2.OrderNo);
• E)None of the above is a correctly stated correlated subquery.

---

Definitions:

Vestibular Sense

The sensory system that provides the leading contribution to the sense of balance and spatial orientation for the purpose of coordinating movement with balance.

Kinesthesia

Kinesthesia is the sensory ability to perceive and recognize the movement and position of one's body and limbs, without using sight.

Deactivation

The process of turning off or disabling a system or chemical reaction.

Stimulus Energies

Various forms of energy, such as light, sound, and touch, that can elicit a response from an organism or a sensor.