单项选择题

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

You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）

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

<上一题目录下一题>

热门试题

单项选择题YouaremaintainingtheSALESdatabaseforeSoftCorporation.YouhavenotconfiguredASMMonthedatabase.YouwanttoknowwhatsizeoftheSGAwillprovidethebestperformance.WhichadvisorwouldyouusetodeterminethesuitablesizeoftheSGA？（）

A. SQL Tuning Advisor
B. Undo Advisor
C. ADDM
D. Memory Advisor

单项选择题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.