多选题Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt， and has to be re-created.DThe index is automatically rebuilt when used the next time
多选题
Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）
A
It is ignored by the query optimizer.
B
It is not used while the index is being rebuilt.
C
The index cannot be rebuilt， and has to be re-created.
D
The index is automatically rebuilt when used the next time
参考解析
解析：
暂无解析
相关考题：
Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA．ⅠonlyB．Ⅱ onlyC．Ⅰ and ⅡD．none of the above
Which statement is true about the plan being loaded into the SQL baseline by the above command?() A. It is loaded with the FIXED status.B. It is loaded with the ACCEPTED status.C. It is not loaded with the ENABLED status.D.It is not loaded with the ACCEPTED status.
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?（）A. The index remains invisible.B. The index is not updated by the DML statements on the indexed table.C. The index automatically becomes visible in order to have it updated by DML on the table.D. The index becomes unusable but the table is updated by the DML.E. The index is updated by the DML on the table.
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
Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?（）A、UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%B、UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%C、UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'D、UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
Which of the following dbx commands should be used to obtain a stack trace from a coredump file?（）A、trace B、where C、status D、which
Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）A、It is ignored by the query optimizer.B、It is not used while the index is being rebuilt.C、The index cannot be rebuilt， and has to be re-created.D、The index is automatically rebuilt when used the next time
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 following PL/SQL block： DECLARE my_plans pls_integer； BEGIN my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id= ？9twu5t2dn5xd？； END； Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）A、 It is loaded with the FIXED status.B、 It is loaded with the ACCEPTED status.C、 It is not loaded with the ENABLED status.D、 It is not loaded with the ACCEPTED status.
Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）A、A CHECK constraint is created on the OID column.B、A NOT NULL constraint is created on the OID column.C、The ORDERS table is the only object created in the USERS tablespace.D、The ORDERS table and a unique index are created in the USERS tablespace.E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
Which two statements are true regarding subqueries? （）A、A subquery can retrieve zero or more rows B、Only two subqueries can be placed atone level C、A subquery can be used only in SQL query statements D、A subquery can appear on either side of a comparison operator E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）A、INDEXESB、SKIP_INDEXES_MAINTENANCEC、SKIP_UNUSABLE_INDEXESD、RESUMABLEE、INDEXES_UNUSABLE
Note the output of the following query； SQL SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table： ALTER TABLE exchange_rate FLASHBACK ARCHIEVE； What is the outcome of this command？（） A、 The table uses the default Flashback Data Archive.B、 The Flashback Data Archive Is created In the SYSAUX tablespace.C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）A、The index remains invisible.B、The index is not updated by the DML statements on the indexed table.C、The index automatically becomes visible in order to have it updated by DML on the table.D、The index becomes unusable but the table is updated by the DML.E、The index is updated by the DML on the table.
多选题Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
多选题Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt， and has to be re-created.DThe index is automatically rebuilt when used the next time
多选题Which two statements are true regarding subqueries? （）AA subquery can retrieve zero or more rowsBOnly two subqueries can be placed atone levelCA subquery can be used only in SQL query statementsDA subquery can appear on either side of a comparison operatorEThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
单选题Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）AThe two statements produce identical results.BThe second statement returns a syntax error.CThere is no need to specify DESC because the results are sorted in descending order by default.DThe two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
多选题Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.
多选题You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）AThe index remains invisible.BThe index is not updated by the DML statements on the indexed table.CThe index automatically becomes visible in order to have it updated by DML on the table.DThe index becomes unusable but the table is updated by the DML.EThe index is updated by the DML on the table.
多选题Which two statements are true about a bitmap index？ （）AIt is recommended for the columns that have unique values.BIt can be converted to a B-tree index by using the ALTER INDEX command.CIt has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.DUpdating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.
多选题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
多选题Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt， and has to be re-created.DThe index is automatically rebuilt when used the next time
单选题Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）AINDEXESBSKIP_INDEXES_MAINTENANCECSKIP_UNUSABLE_INDEXESDRESUMABLEEINDEXES_UNUSABLE
多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
多选题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
多选题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