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