A. SQL Tuning AdvisorB. Undo AdvisorC. ADDMD. Memory Ad……

单项选择题You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）

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

单项选择题YouarecreatingaSQLTuningSettoallowagroupofSQLstatementstobepassedintotheSQLTuningAdvisor.WhichpackageswillyouusetocreatetheSQLTuningSet？（）

A. DBMS_WORKLOAD_REPOSITORY
B. DBMS_RESOURCE_MANAGER
C. DBMS_SQLTUNE
D. DBMS_ADVISOR

单项选择题Youcreateatableinyourdatabasethatcontains50，000rowsapproximately.Thequeriesperformedonthetablearecomplexandperformedonthetablefrequently.Whichadvisorhelpsyouachievethebestperformanceofdatabaseforqueriesbyrecommendingtheappropriateindexes？（）

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’