单选题You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）A Flashback TableB Flashback QueryC Flashback Version QueryD Flashback Transaction Query

考题 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;

查看答案

考题 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 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_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. composite index on ORDER_ID and ORDER_DATE

查看答案

考题 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_NOB、ORDER_IDC、STATUSD、PROD_IDE、ORD_TOTALF、composite index on ORDER_ID and ORDER_DATE

查看答案

考题 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 INSERTB、 Unconditional INSERTC、 Conditional ALL INSERTD、 Conditional FIRST INSERT

查看答案

考题 You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A、 You must configure OMF in your database.B、 You must enable block change tracking feature in your database.C、 You must enable ROW MOVEMENT feature on the ORDERS table.D、 You must use the Flashback Version Query before using the Flashback Table feature.

查看答案

考题单选题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 INSERTB Unconditional INSERTC Conditional ALL INSERTD Conditional FIRST INSERT

查看答案

考题多选题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? （）ASELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;BSELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;CSELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;DSELECT customer_id, order_id, order_total FROM orders WHERE order_total= 100 and = 2000;ESELECT customer_id, order_id, order_total FROM orders WHERE order_total= 100 and order_total = 2000;

查看答案

考题单选题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 1999C displaying the number of orders that have order mode online and order date in 1999D displaying the number of orders whose order total is more than the average order total for all online orders

查看答案

考题单选题Which statement accomplish this?（）A CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);B CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);C CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);D CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);E CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);F CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

查看答案

考题单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A Export and import the mapping table.B Drop and re-create the mapping table.C Truncate the mapping table and reinsert the values.D Use the ALTER TABLE .. REBUILD command to defragment the mapping table.

查看答案

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

查看答案

考题单选题You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）A You must configure OMF in your database.B You must enable block change tracking feature in your database.C You must enable ROW MOVEMENT feature on the ORDERS table.D You must use the Flashback Version Query before using the Flashback Table feature.

查看答案

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

查看答案

考题多选题Evaluate the following statements： CREATE TABLE purchase_orders （po_id NUMBER（4）， po_date TIMESTAMP， supplier_id NUMBER（6）， po_total NUMBER（8，2）， CONSTRAINT order_pk PRIMARY KEY（po_id）） PARTITION BY RANGE（po_date）（PARTITION Q1 VALUES LESS THAN （TO_DATE（？1-apr-2007？d-mon-yyyy？）， PARTITION Q2 VALUES LESS THAN （TO_DATE（？1-jul-2007？d-mon-yyyy？）， PARTITION Q3 VALUES LESS THAN（TO_DATE（？1-oct - 2007？d-mon-yyyy？）， PARTITION Q4 VALUES LESS THAN （TO_DATE（？1-jan-2008？d-mon-yyyy？））； CREATE TABLE purchase_order_items （po_id NUMBER（4） NOT NULL， product_id NUMBER（6） NOT NULL， unit_price NUMBER（8，2）， quantity NUMBER（8）， CONSTRAINT po_items_fk FOREIGN KEY （po_id） REFERENCES purchase_orders（po_id）） PARTITION BY REFERENCE（po_items_fk）； What are the two consequences of the above statements？（）APartitions of PURCHASE_ORDER_ITEMS have system-generated names.BBoth PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.CPartitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.DThe PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.EPartition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

查看答案

考题单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A export and import the mapping tableB drop and re-create the mapping tableC truncate the mapping table and reinsert the valuesD use the ALTER TABLE···REBUILD command to defragment the mapping table

查看答案

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

查看答案

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

查看答案

考题单选题You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）A Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.B Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.C Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.D Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.

查看答案

考题单选题In the data model you created this query: SELECT ID_no, description, price, quantity, manufacturer_ID FROM inventory Next you click and drag the manufacturer_ID column out of and above the default group. You needed to sort the child group by ID_number. How could you accomplish this task? （）A Add an order by clause to the query. B In the data model double click the ID_number column and alter the break order. C In the layout model double click the ID_number filed and later the print direction. D Default the layout, choose a master/detail report style and select ID_number as the break order.

查看答案

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

查看答案

考题多选题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? （）ASELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;BSELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;CSELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;DSELECT customer_id, order_id, order_total FROM orders WHERE order_total= 100 and = 2000;ESELECT customer_id, order_id, order_total FROM orders WHERE order_total= 100 and order_total = 2000;

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：