单项选择题

A. Memory AdvisorB. Segment AdvisorC. Undo AdvisorD. SQ……

While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

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

<上一题目录下一题>

热门试题

单项选择题WhichcomponentdoestheSQLTuningAdvisorNOTanalyzefortheSQLstatements？（）

A.ADDM
B.AWR
C.Cursor Cache
D.SQL Tuning Sets
E.Flash Recovery Area

单项选择题Youfindthatsomequeriesonatablearetakingalongtimetoexecutebecausetherearenoindexescreatedonthetable.YoudecidetoinvoketheSQLAccessAdvisortodeterminetheappropriateindextobecreated.WhichpackagewillyouusetoinvoketheSQLAccessAdvisor？（）

A.DBMS_SERVER_ALERT
B.DBMS_ADVISOR
C.DBMS_RESOURCE_MANAGER
D.DBMS_REPAIR

单项选择题YoufindpocketsofemptyspaceintheUSER_DATAtablespaceduetoalotofDMLoperationsontheobjectsintheUSER_DATAtablespace.Thepocketsofemptyspacesaretoosmalltobereusedindividually.Thisisleadingtowastageofspace.Youdecidetoperformtheshrinkoperationtoreclaimthewastedspace.WhichadvisorwillyouusetodeterminetheobjectsintheUSER_DATAtablespacethataregoodcandidatesfortheshrinkoperation？（）

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