单选题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？（）

displaying the total order value for sales representatives 161 and 163

displaying the order total for sales representative 161 in the year 1999

displaying the number of orders that have order mode online and order date in 1999

displaying the number of orders whose order total is more than the average order total for all online orders

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

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

点击查看答案
第2题

多选题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? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFcomposite index on ORDER_ID and ORDER_DATE

点击查看答案
第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？（）APivoting INSERTBUnconditional INSERTCConditional ALL INSERTDConditional FIRST INSERT

点击查看答案
第4题

单选题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？（）AUse a subreport.BUse a bookmark link.CUse the drilldown functionality.DUse a drillthrough report link.

点击查看答案
第5题

多选题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? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE

点击查看答案
第6题

多选题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? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFcomposite index on ORDER_ID and ORDER_DATE

点击查看答案
第7题

多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite 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题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

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

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

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