[单选]
Examine the data from the ORDERS and CUSTOMERS tables.
ORDERS
ORD_ID ORD_DATE CUST_ID
12-JAN-
100 15 10000
09-MAR-
101 40 8000
09-MAR-
102 35 12500
15-MAR-
103 15 12000
25-JUN-
104 15 6000
18-JUL-
105 20 5000
106 18-JUL- 35 7000
21-JUL-
107 20 6500
04-AUG-
109 10 8000
CUSTOMERS
CUST_ID CUST_NAME CITY
10 Smith Los Angeles
15 Bob San Francisco
20 Martin Chicago
25 Mary New York
30 Rina Chicago
35 Smith New York
40 Lind New York
Evaluate the SQL statement:
SELECT *
FROM orders
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_name = 'Smith');
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.

先叶开花的植物备用的主要发供电设备，不能按调度规定的时间投入运行，应算（）。事故。一类障碍。三类障碍。 The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?（） Minimum widow records. 。 Column mode. 。 Spacing 。 Print direction. 。 Source F maximum records per page. 。 Maximum records per page.。在酸性尿液中弱碱性药物（）。解离少，再吸收多，排泄慢。解离多，再吸收少，排泄快。解离少，再吸收少，排泄快。解离多，再吸收多，排泄慢。 E。排泄速度不变。 Which two statements are true regarding the usage of the SQL*Loader utility（） You can load data into multiple tables during the same load session.。 You can load data from multiple files to a table during the same load session.。 You cannot perform selective data loading based on the values available in the records.。 You can use an export file generated by the EXPDP utility as an input data file to load the data.。 You can load data only if the input file is available on the disk and tape but not in a named pipes.。

Examine the data from the ORDERS and CUSTOMERS tables.
ORDERS
ORD_ID ORD_DATE CUST_ID
12-JAN-
100 15 10000
09-MAR-
101 40 8000
09-MAR-
102 35 12500
15-MAR-
103 15 12000
25-JUN-
104 15 6000
18-JUL-
105 20 5000
106 18-JUL- 35 7000
21-JUL-
107 20 6500
04-AUG-
109 10 8000
CUSTOMERS
CUST_ID CUST_NAME CITY
10 Smith Los Angeles
15 Bob San Francisco
20 Martin Chicago
25 Mary New York
30 Rina Chicago
35 Smith New York
40 Lind New York
Evaluate the SQL statement:
SELECT *
FROM orders
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_name = 'Smith');
What is the result when the query is executed?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

相关题目: