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

题目
单选题
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');

相似考题

1.尿细菌定量培养是诊断有无尿路感染的重要指标。革兰阴性杆菌感染，尿含菌量为A、104～105/mlB、103～104/mlC、10～102/mlD、102～103/mlE、105～106/ml球菌感染，尿含菌量为A、104～105/mlB、103～104/mlC、10～102/mlD、102～103/mlE、105～106/ml

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 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.

4.影像增强管的总增益一般在A.102～103之间B.10～102之间C.104～105之间D.103～104之间E.105～106之间

更多“单选题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 700”相关问题

  • 第1题：

    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

  • 第2题：

    尿细菌定量培养，可疑阳性需复查的是

    A、102-103/ml
    B、103-104/ml
    C、104-105/ml
    D、105-106/ml
    E、＞106/ml

    答案：C
    解析：
    尿细菌定量培养104-105/ml，为可疑阳性，需复查。（注：104-105/ml，这里是指尿细菌定量培养数值104/ml，且105/ml时，为可以阳性，若等于105/ml，则有可能为尿路感染）

  • 第3题：

    数列“102、103、104、105、106”的算术平均数是（）。

    • A、102
    • B、103
    • C、104
    • D、105

    正确答案:C

  • 第4题：

    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

  • 第5题：

    电流1A＝（）mA＝106μA。

    • A、102；
    • B、103；
    • C、104；
    • D、105。

    正确答案:B

  • 第6题：

    分馏塔分为（）塔和（）塔。C-101、102、103、C-104属于（）C-105、106、107属于（）。


    正确答案:填料塔；板式塔；填料塔；板式塔

  • 第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题：

    单选题
    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');


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    现有客户表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


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    尿细菌定量培养是诊断有无尿路感染的重要指标。球菌感染，尿含菌量为（）
    A

    104～105/ml

    B

    103～104/ml

    C

    10～102/ml

    D

    102～103/ml

    E

    105～106/ml


    正确答案： B
    解析： 暂无解析

  • 第13题：

    Inthisscenario，assumethatyouarchivelogs101to104totwoarchivingdestinations，/log1and/log2.Thecontrolfilecontainsarchivedlogrecordsasfollows：

    SequenceFilename

    101/log1/log_1_101.arc

    101/log2/log_1_101.arc

    102/log1/log_1_102.arc

    102/log2/log_1_102.arc

    103/log1/log_1_103.arc

    103/log2/log_1_103.arc

    104/log1/log_1_104.arc

    104/log2/log_1_104.arc

    Youaccidentallydeletelogs102and104fromlog1.Yourunthiscommand：

    BACKUPARCHIVELOGFROMSEQUENCE101UNTILSEQUENCE105；

    Whathappens？（）


    参考答案：D

  • 第14题：

    正比计数器的电荷倍增约为（）

    • A、101-102
    • B、103-104
    • C、105-106
    • D、107-108
    • E、109-1010

    正确答案:B

  • 第15题：

    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.

    正确答案:D

  • 第16题：

    尿细菌定量培养是诊断有无尿路感染的重要指标。球菌感染，尿含菌量为（）

    • A、104～105/ml
    • B、103～104/ml
    • C、10～102/ml
    • D、102～103/ml
    • E、105～106/ml

    正确答案:B

  • 第17题：

    数列"101、102、103、104、105"的中位数是103。（）


    正确答案:正确

  • 第18题：

    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

  • 第19题：

    电流1A=（）mA=106μA。

    • A、102
    • B、103
    • C、104
    • D、105

    正确答案:B

  • 第20题：

    填空题
    分馏塔分为（）塔和（）塔。C-101、102、103、C-104属于（）C-105、106、107属于（）。

    正确答案： 填料塔,板式塔,填料塔,板式塔
    解析： 暂无解析

  • 第21题：

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


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    应用PCR检测结核杆菌时，每毫升标本中含有多少可以检测出（）
    A

    10～102

    B

    102～103

    C

    103～104

    D

    104～105

    E

    105～106


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

  • 第23题：

    多选题
    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'


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

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容