【单选题】
Examine the data from the ORDERS and CUSTOMERS tables.<br /> ORDERS<br /> ORD_ID ORD_DATE CUST_ID<br /> 12-JAN-<br /> 100 15 10000<br /> 09-MAR-<br /> 101 40 8000<br /> 09-MAR-<br /> 102 35 12500<br /> 15-MAR-<br /> 103 15 12000<br /> 25-JUN-<br /> 104 15 6000<br /> 18-JUL-<br /> 105 20 5000<br /> 106 18-JUL- 35 7000<br /> 21-JUL-<br /> 107 20 6500<br /> 04-AUG-<br /> 109 10 8000<br /> CUSTOMERS<br /> CUST_ID CUST_NAME CITY<br /> 10 Smith Los Angeles<br /> 15 Bob San Francisco<br /> 20 Martin Chicago<br /> 25 Mary New York<br /> 30 Rina Chicago<br /> 35 Smith New York<br /> 40 Lind New York<br /> Evaluate the SQL statement:<br /> SELECT *<br /> FROM orders<br /> WHERE cust_id = (SELECT cust_id<br /> FROM customers<br /> WHERE cust_name = 'Smith');<br /> What is the result when the query is executed?（）
A、ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000
B、ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000
C、ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000
D、The query fails because the subquery returns more than one row.
E、The query fails because the outer query and the inner query are using different tables.
查看正确答案
