单项选择题

A.SQL Access AdvisorB. Memory AdvisorC.SQL Tuning Advis……

You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）

A.SQL Access Advisor
B. Memory Advisor
C.SQL Tuning Advisor
D. Segment Advisor

<上一题目录下一题>

热门试题

单项选择题You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）

A. Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE
B. Use the ANALYZE utility.
C. Use the DBVERIFY utility.
D. Use the DBMS_REPAIR package.

单项选择题William specified the following initialization parameter settings in the pfile： BACKGROUND_DUMP_DEST = ’u01 oradata dir_A’ USER_DUMP_DEST = ’u01 oradata dir_B’ DB_CREATE_FILE_DEST = ’u01 oradata dir_C’ DB_CREATE_ONLINE_LOG_DEST_n = ’u01 oradata dir_D’ William enabled the change-tracking feature because he does not want to scan the entire datafile during backup. What is the default storage location for the change tracking file？（）

A. ’u01\oradata\dir_A’
B. ’u01\oradata\dir_B’
C. ’u01\oradata\dir_C’
D. ’u01\oradata\dir_D’

单项选择题YouwanttochecktheEMPtableintheuser，Scott’sschemaforblockcorruption.Youalsowanttofixthecorruptedblocks，ifany.Howwillyouaccomplishtherequiredtask？（）

A.by using the ANALYZE utility
B.by using the DBVERIFY utility
C.by using the DB_BLOCK_CHECKING parameter
D.by using the DBMS_REPAIR package

单项选择题YouareusingtheDBVERIFYutilitytocheckthedatafilesforanyblockcorruption.Youwanttowritetheoutputofthedbvcommandtoafilenottothescreen.WhichparameteroftheDBVERIFYutilitywillyouuse？（）

A. FILE
B. PARFILE
C. LOGFILE
D. FEEDBACK

单项选择题While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01 oracle oradata data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）

A. Block Media Recovery must be used with RMAN.
B. You must perform complete recovery of individual blocks.
C. You must have a full RMAN backup， not an incremental backup.
D. You must use the DBVERIFY utility before using the Block Media Recovery feature.