black

1z0-043

登录

单项选择题

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_DATAtablespaceduetoalotofDMLoperationsontheobjectsintheUSER_DATAtablespace.Thepocketsofemptyspacesaretoosmalltobereusedindividually.Thisisleadingtowastageofspace.Youdecidetoperformtheshrinkoperationtoreclaimthewastedspace.WhichadvisorwillyouusetodeterminetheobjectsintheUSER_DATAtablespacethataregoodcandidatesfortheshrinkoperation?()

单项选择题 YouaremaintainingtheSALESdatabaseforeSoftCorporation.YouhavenotconfiguredASMMonthedatabase.YouwanttoknowwhatsizeoftheSGAwillprovidethebestperformance.WhichadvisorwouldyouusetodeterminethesuitablesizeoftheSGA?()

单项选择题 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?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064