niusouti.com

单选题View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries？  （）Adisplaying the total order value for sales representatives 161 and 163Bdisplaying the order total for sales representative 161 in the year 1999Cdis

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

相似考题

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

3.Click the Exhibit button and examine the data from the EMP table.The COMMISSION column shows the monthly commission earned by the employee.Which two tasks would require subqueries or joins in order to be performed in a single step? （）A.listing the employees who earn the same amount of commission as employee 3B.finding the total commission earned by the employees in department 10C.finding the number of employees who earn a commission that is higher than the average commission of the companyD.listing the departments whose average commission is more than 600E.listing the employees who do not earn commission and who are working for department 20 in descending order of the employee IDF.listing the employees whose annual commission is more than 6000

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

更多“单选题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 163B  displaying the order total for sales representative 161 in the year 19”相关问题

  • 第1题：

    The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）

    • A、Report wizard. 
    • B、Layout model. 
    • C、Data model. 
    • D、Life previewer.

    正确答案:C

  • 第2题：

    tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）

    • A、select the parenthesis when negative value in the view properties box 
    • B、select the parenthesis when negative value in the column properties box 
    • C、use the @function @negative to set this in the column formula in the view 
    • D、use a formula to format the value in the field on the form that will be displaying in the view

    正确答案:B

  • 第3题：

    The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be added to the ORDERJHISTORY table， and order ID and customer ID should be added to the CUSTJHISTORY table.   Which multitable INSERT statement would you use？ （）

    • A、 Pivoting INSERT
    • B、 Unconditional INSERT
    • C、 Conditional ALL INSERT
    • D、 Conditional FIRST INSERT

    正确答案:C

  • 第4题：

    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;

    正确答案:C,E

  • 第5题：

    单选题
    管理Oracle数据库。Jack负责管理“销售”部门。他和他的雇员经常需要查询数据库以确定客户及其订单。他要求您创建一个视图，为他和他的同事简化此过程。此视图不接受INSERT、UPDATE或DELETE操作。应执行以下哪条语句（）
    A

    CREATE VIEW sales_view AS（SELECT companyname，city，orderid，orderdate，total FROM customers，orders WHERE custid=custid}WITHREAD ONLY

    B

    CREATE VIEW sales_view（SELECT c.companyname，c.city，o.orderid，o.orderdate，o.tota lFROM customersc，orderso WHERE c.custid=o.custid}WITHREAD ONLY

    C

    CREATE VIEW sales_view AS（SELECT c.companyname，c.city，o.orderid，o.orderdate，o.total FROM customersc，orderso WHERE c.custid=o.custid}

    D

    CREATE VIEW sales_view AS（SELECT c.companyname，c.city，o.orderid，o.orderdate，o.total FROM customersc，orderso WHERE c.custid=o.custid）WITHREAD ONLY


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

  • 第6题：

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


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

  • 第7题：

    单选题
    The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）
    A

    Report wizard. 

    B

    Layout model. 

    C

    Data model. 

    D

    Life previewer.


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

  • 第8题：

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


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

  • 第9题：

    多选题
    View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries？ （）
    A

    displaying the minimum list price for each product status

    B

    displaying all supplier IDs whose average list price is more than 500

    C

    displaying the number of products whose list prices are more than the average list price

    D

    displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable

    E

    displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE


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

  • 第10题：

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

  • 第11题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）
    A

     Use a subreport.

    B

     Use a bookmark link.

    C

     Use the drilldown functionality.

    D

     Use a drillthrough report link.


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

  • 第12题：

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


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

  • 第13题：

    The total CIP value of your order comes（）$960 instead of $690，the difference（）$270.

    • A、to，be
    • B、at，being
    • C、to，being
    • D、at，tobe

    正确答案:C

  • 第14题：

    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

  • 第15题：

    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

    正确答案:A,F

  • 第16题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）

    • A、 Use a subreport.
    • B、 Use a bookmark link.
    • C、 Use the drilldown functionality.
    • D、 Use a drillthrough report link.

    正确答案:D

  • 第17题：

    单选题
    The total CIP value of your order comes（）$960 instead of $690，the difference（）$270.
    A

    to，be

    B

    at，being

    C

    to，being

    D

    at，tobe


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

  • 第18题：

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

  • 第19题：

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

  • 第20题：

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


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

  • 第21题：

    单选题
    tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）
    A

    select the parenthesis when negative value in the view properties box 

    B

    select the parenthesis when negative value in the column properties box 

    C

    use the @function @negative to set this in the column formula in the view 

    D

    use a formula to format the value in the field on the form that will be displaying in the view


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

  • 第22题：

    单选题
    The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be added to the ORDERJHISTORY table， and order ID and customer ID should be added to the CUSTJHISTORY table.   Which multitable INSERT statement would you use？ （）
    A

     Pivoting INSERT

    B

     Unconditional INSERT

    C

     Conditional ALL INSERT

    D

     Conditional FIRST INSERT


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

  • 第23题：

    多选题
    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,F
    解析： 暂无解析

  • 第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
    解析： 暂无解析

相关内容