CMS专题
多选题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题：
You have a computer that runs Windows Vista Ultimate.You open the Windows System Performance Rating tool and receive a Windows Experience Index base score of 1.0. The subscores are as follows:·Processor: 4.7·Memory (RAM): 3.6·Graphics: 1.0·Gaming Graphics: 1.0·Primary Hard Disk: 3.0You upgrade your video adapter card with a new card that meets the minimum requirements for Windows Aero.You open the System Performance and Rating tool and notice the base score and subscores have not changed.You need to enable Windows Aero.What should you do?（）
A.A
B.B
C.C
D.D
第2题：
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）
- A、 Start the database in OPEN mode， and create a new index tablespace.
- B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.
- C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.
- D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
正确答案:D
第3题：
A.jealous of
B.invisible to
C.superior to
D.impatient for
解析：句子的意思：他们________你是因为你在学校一点问题都没有。Be jealous of, 嫉妒，羡慕;be invisible to, 看不见的，不可见的;be superior to, 优于;级别高于;be impatient for, 渴望;迫不及待要得到。
第4题：
You issued the following statement to monitor the usage of the index： SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）
- A、 INDEX_STATS
- B、 DBA_INDEXES
- C、 DBA_IND_COLUMNS
- D、 V$OBJECT_USAGE
正确答案:D
第5题：
While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn 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
第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 executed the following procedure to collect statistics regarding an index： SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）
- A、 INDEX_STATS
- B、 DBA_INDEXES
- C、 DBA_IND_COLUMNS
- D、 V$OBJECT_USAGE
正确答案:A
第8题：
View the Exhibit for some of the parameter settings. You start a session and issue the following command:SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;What is the outcome of the above command?（）
A. The index is not used by the optimizer but is maintained during DML operations.
B. The index is not used by the optimizer and is not maintained during DML operations.
C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.
第9题：
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
第10题：
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
- A、 by using the Flashback Database feature
- B、 by using RMAN incomplete recovery
- C、 by performing a user-managed incomplete recovery
- D、 by dropping and re-creating the index tablespace
正确答案:D