An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:<br /> SQL>CREATE INDEX ord_custname_ix ON orders(custname);<br /> The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.<br /> You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）..

第1题

[多选题] On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）

A、Both the indexes are created; however, only the ORD_COSTOMER index is visible. B、The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan. C、Only the ORD_CUSTOMER_IX1 index is created. D、Only the ORD_CUSTOMER_IX2 index is created. E、Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

点击查看答案

第2题

[多选题] On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）

A、Only the ORD_CUSTOMER_IX1 index created. B、Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table. C、Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table. D、The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true. E、Both the indexes are created and used by the optimizer for queries on the ORDERS table. F、Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

点击查看答案

第3题

[单选题] An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command： SQL>CREATE INDEX ord_custname_ix ON orders（custname）； The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test. Which is the most efficient method of performing this task？（）

A、 disabling the index B、 making the index invisible C、 making the index unusable D、 using the MONITORING USAGE clause for the index

点击查看答案

第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_NO B、ORDER_ID C、STATUS D、PROD_ID E、ORD_TOTAL F、Composite index on ORDER_ID and ORDER_DATE

点击查看答案

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

A、SER_NO B、ORDER_ID C、STATUS D、PROD_ID E、ORD_TOTAL F、Composite index on ORDER_ID and ORDER_DATE

点击查看答案

第6题

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

点击查看答案

第7题

[] 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? （） 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、A. SER_NO B、B. ORDER_ID C、C. STATUS D、D. PROD_ID E、E. ORD_TOTAL F、F. composite index on ORDER_ID and ORDER_DATE

点击查看答案

第8题

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

点击查看答案

第9题

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

点击查看答案

请使用微信扫码支付