单选题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-

题目

单选题

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?（）

ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000

ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000

ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000

The query fails because the subquery returns more than one row.

The query fails because the outer query and the inner query are using different tables.

相似考题

1.The ORDERS table has these columns:ORDER_ID NUMBER(4) NOT NULLCUSTOMER_ID NUMBER(12) NOT NULLORDER_TOTAL NUMBER(10,2)The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs.Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）A. SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;B. SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;C. SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;D. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;E. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

2.Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?()A.B.C.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.

3.Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE

4.Examine the SQL statements that creates ORDERS table: CREATE TABLE orders(SER_NO NUMBER UNIQUE,ORDER_ID NUMBER,ORDER_DATE DATE NOT NULLSTATUS VARCHARD2(10)CHECK (status IN (‘CREDIT‘,‘CASH‘)),PROD_ID_NUMBERREFERENCES PRODUCTS(PRODUCT_ID),ORD_TOTAL NUMBER,PRIMARY KEY (order id, order date));For which columns would an index be automatically created when you execute the aboveSQL statement? （）A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE

更多“Examine the data from the ORDERS and CUSTOMERS tables. ORDER”相关问题

第1题：

Examine the data from the ORDERS and CUSTOMERS table.Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）
A.
B.
C.
D.

参考答案：B
第2题：

The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？（）
- A、 PUBLIC should be replaced with specific usernames.
- B、 ALL should be replaced with a list of specific privileges.
- C、 WITH GRANT OPTION should be added to the statement.
- D、 Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
正确答案:D
第3题：

现有客户表customers（主键：客户编号cid），包含10行数据，订单表orders（外键：客户编号cid），包含6条数据。执行sql语句：select * from customers right outer join orders on customers.cid=orders.cid。最多返回（）条记录。
- A、10
- B、6
- C、4
- D、0
正确答案:B
第4题：

From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.
- A、Updating
- B、Viewing
- C、Deleting
- D、Inserting
- E、Truncating
正确答案:B,D
第5题：

多选题
The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_TOTAL NUMBER(10,2) The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）
A
SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;
B
SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;
C
SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;
D
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;
E
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

正确答案： B,A
解析：暂无解析
第6题：

单选题
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？（）
A
PUBLIC should be replaced with specific usernames.
B
ALL should be replaced with a list of specific privileges.
C
WITH GRANT OPTION should be added to the statement.
D
Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.

正确答案： D
解析：暂无解析
第7题：

多选题
TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）
A
ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders
B
DROP TRIGGER trg InsertOrders
C
DISABLE TRIGGER trg InsertOrders ON Orders
D
ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION

正确答案： A,C
解析：暂无解析
第8题：

单选题
Examine the data from the ORDERS and CUSTOMERS table. ORDERS ORD_ID ORD_DATE CUST_ID ORD_TOTAL 100 12-JAN-2000 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 104 25-JUN-2000 15 6000 105 18-JUL-2000 20 5000 106 18-JUL-2000 35 7000 107 21-JUL-2000 20 6500 04-AUG- 108 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 Linda New York Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）
A
SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Mating' AND ord _ date IN ('18-JUL-2000','21-JUL-2000');
B
SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'MARTIN'));
C
SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = 'Martin');
D
SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = 'Martin');

正确答案： D
解析：暂无解析
第9题：

单选题
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin placed his orders?（）
A
SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Martin' AND ord_date IN ('18-JUL-2000','21-JUL-2000');
B
SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Martin'));
C
SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders, customers WHERE cust_name = 'Martin');
D
SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust_name = 'Martin');

正确答案： C
解析：暂无解析
第10题：

单选题
You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）
A
CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );
B
CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
C
CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
D
CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
E
CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
F
CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );

正确答案： F
解析：暂无解析
第11题：

多选题
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.
A
Updating
B
Viewing
C
Deleting
D
Inserting
E
Truncating

正确答案： B,E
解析：暂无解析
第12题：

单选题
Examine the data from the ORDERS and CUSTOMERS table. ORDERS ORD_ID ORD_DATE CUST_ID ORD_TOTAL 100 12-JAN-2000 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 104 25-JUN-2000 15 6000 105 18-JUL-2000 20 5000 106 18-JUL-2000 35 7000 107 21-JUL-2000 20 6500 04-AUG- 108 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 Linda New York Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）
A
SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Mating' AND ord _ date IN ('18-JUL-2000','21-JUL-2000');
B
SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'MARTIN'));
C
SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = 'Martin');
D
SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = 'Martin');

正确答案： B
解析：暂无解析
第13题：

Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）
A.A
B.B
C.C
D.D
E.E

参考答案：A
第14题：

Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?（）
- A、 ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders
- B、 DROP TRIGGER trg_InsertOrders
- C、 DISABLE TRIGGER trg_InsertOrders ON Orders
- D、 ALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATION
- E、 sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'
正确答案:A,C
第15题：

假设订单表orders用来存储订单信息，cid代表客户编号，money代表单次订购额，现要查询每个客户的订购次数和每个客户的订购总金额，下面（）sql语句可以返回正确结果。
- A、select cid,count(distinct(cid)),sum(money) from orders group by cid
- B、select cid,count(distinct(cid)),sum(money) from orders order by cid
- C、select cid,count(cid),sum(money) from orders order by cid
- D、select cid,count(cid),sum(money) from orders group by cid
正确答案:D
第16题：

单选题
View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）
A
The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.
B
The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 3.
C
The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 4.
D
The ORDERS MASTER table would contain the ORDER IDs 1， 2， 3 and 4.

正确答案： B
解析：暂无解析
第17题：

单选题
View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement： SELECT oi.order_id， product_jd， order_date FROM order_items oi JOIN orders o USING （order_id）； Which statement is true regarding the execution of this SQL statement？（）
A
The statement would not execute because table aliases are not allowed in the JOIN clause.
B
The statement would not execute because the table alias prefix is not used in the USING clause.
C
The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.
D
The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.

正确答案： B
解析：暂无解析
第18题：

单选题
View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries？（）
A
displaying the total order value for sales representatives 161 and 163
B
displaying the order total for sales representative 161 in the year 1999
C
displaying the number of orders that have order mode online and order date in 1999
D
displaying the number of orders whose order total is more than the average order total for all online orders

正确答案： D
解析：暂无解析
第19题：

多选题
Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN ('CREDIT','CASH')), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); For which columns would an index be automatically created when you execute the aboveSQL statement? （）
A
SER_NO
B
ORDER_ID
C
STATUS
D
PROD_ID
E
ORD_TOTAL
F
Composite index on ORDER_ID and ORDER_DATE

正确答案： C,A
解析：暂无解析
第20题：

多选题
You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）
A
SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC
B
SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit
C
SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST
D
SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST

正确答案： B,C
解析：暂无解析
第21题：

多选题
Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
A
SER_NO
B
ORDER_ID
C
STATUS
D
PROD_ID
E
ORD_TOTAL
F
composite index on ORDER_ID and ORDER_DATE

正确答案： A,F
解析：暂无解析
第22题：

多选题
Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?（）
A
ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders
B
DROP TRIGGER trg_InsertOrders
C
DISABLE TRIGGER trg_InsertOrders ON Orders
D
ALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATION
E
sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'

正确答案： B,E
解析：暂无解析
第23题：

多选题
The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_TOTAL NUMBER(10,2) The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）
A
SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;
B
SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;
C
SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;
D
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;
E
SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

正确答案： A,D
解析：暂无解析
第24题：

多选题
Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）
A
SER_NO
B
ORDER_ID
C
STATUS
D
PROD_ID
E
ORD_TOTAL
F
Composite index on ORDER_ID and ORDER_DATE

正确答案： C,F
解析：暂无解析

单选题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-

题目

相似考题

更多“Examine the data from the ORDERS and CUSTOMERS tables. ORDER”相关问题

相关内容