Which of the Following SQL Statements Is a Correctly Stated

question 5

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.SalesRepNo
• 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);

---

Definitions:

Hostile Working Environment

A situation where an employee finds the workplace unbearable due to harassment, discrimination, or any behavior that severely affects their ability to work.

Quid Pro Quo Harassment

A form of sexual harassment where job benefits or decisions are conditioned on submitting to sexual advances or conduct.

Executive Order 11246

A U.S. Presidential mandate that requires government contractors to practice affirmative action and prohibit discrimination on the basis of race, color, religion, sex, or national origin.

Bona Fide Occupational Qualification

A legal term that allows employers to make hiring decisions based on specific attributes when those attributes are essential to the job.