单项选择题
A.ADDM B.AWR C.Cursor Cache D.SQL Tuning Sets E.Flash Recovery Area
Youfindthatsomequeriesonatablearetakingalongtimetoexecu...
单项选择题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）
A.DBMS_SERVER_ALERT B.DBMS_ADVISOR C.DBMS_RESOURCE_MANAGER D.DBMS_REPAIR
YoufindpocketsofemptyspaceintheUSER_DATAtablespacedueto...
单项选择题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.Yo...
单项选择题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）
A. SQL Tuning Advisor B. Undo Advisor C. ADDM D. Memory Advisor
