1Z0-060
多选题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
题目
The index remains invisible.
The index is not updated by the DML statements on the indexed table.
The index automatically becomes visible in order to have it updated by DML on the table.
The index becomes unusable but the table is updated by the DML.
The index is updated by the DML on the table.
相似问题和答案
第1题：
A. SER_NO
B. ORDER_ID
C. STATUS
D. PROD_ID
E. ORD_TOTAL
F. Composite index on ORDER_ID and ORDER_DATE
第2题：
While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
- A、A primary key must have been created.
- B、A mapping table must have been created.
- C、An overflow tablespace must have been specified.
- D、The PCTTHRESHOLD option must have been specified.
正确答案:B
第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题：
You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）
- A、A leaf will be marked as invalid.
- B、An update in a leaf row takes place.
- C、The index will be updated automatically at commit.
- D、A leaf row in the index will be deleted and inserted.
- E、The index becomes invalid when you make any updates
正确答案:D
第5题：
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
正确答案:B
第6题：
While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
- A、A primary key must have been created.
- B、A mapping table must have been created.
- C、An overflow tablespace must have been specified.
- D、The PCTTHRESHOLD option must have been specified.
正确答案:B
第7题：
You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）
- A、 Rebuild the index.
- B、 Coalesce the index.
- C、 Drop and re-create the index in the new tablespace.
- D、 Relocate the index using the ALTER INDEX...MOVE statement.
正确答案:A
第8题：
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.
第9题：
As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）
- A、A leaf will be marked as invalid.
- B、An update in a leaf row takes place.
- C、The index will be updated automatically at commit.
- D、A leaf row in the index will be deleted and inserted.
- E、The index becomes invalid when you make any updates.
正确答案:D
第10题：
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）
- A、 The queries that are currently executing will abort and an error message will be returned to the user.
- B、 The queries that are currently executing will execute normally but future queries will not executed.
- C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.
- D、 The currently executing and future queries will execute normally， but will be slower
正确答案:D