首页计算机考试Oracle认证
(单选题)

You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this?()

Aenable index monitoring and query the DBA_OBJECTS view

Benable index monitoring and query the DBA_INDEXES view

Cenable index monitoring and query the V$OBJECT_USAGE view

Denable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to ()

    答案解析

  • (单选题)

    Exhibit: View the Exhibit.You have more than one table in the recycle bin having the same original name, DEPT2. You do not have any table with the nameDEPT2 in your schema. You executed the following command:PURGE TABLE dept2; Which statement is correct in this scenario?()

    答案解析

  • (单选题)

    Given: Which change can you make to Target without affecting Client?()

    答案解析

  • (单选题)

    You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically, and not have to do it manually.  What should you do?()

    答案解析

  • (单选题)

    Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member.  When you attempt to start the database, you receive the following errors:()

    答案解析

  • (单选题)

    Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database?()  

    答案解析

  • (单选题)

    You have included the following parameter settings in your SPFILE://    SGA_MAX_SIZE=8G   SGA_TARGET=6G   DB_CACHE_SIZE=2G   SHARED_POOL_SIZE=1G   LOG_BUFFER=64M   DB_KEEP_CACHE_SIZE=960M   Which statement is true if you modify the SGA_TARGET initialization parameter?()

    答案解析

  • (单选题)

    Exhibit: Using Database Control, you have scheduled a job to shrink the TRANStable residing on the TTtablespace. The job would run at 5:00 p.m. every Friday.When you examine the space usage of the table after the completion of the job, you find that the table has not been shrunk. What could have been the reason for this?()

    答案解析

  • (单选题)

    You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?()  

    答案解析

  • (单选题)

    You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value?()

    答案解析

快考试在线搜题