black

1z0-043

单项选择题

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？（）

单项选择题 Youcreateatableinyourdatabasethatcontains50，000rowsapproximately.Thequeriesperformedonthetablearecomplexandperformedonthetablefrequently.Whichadvisorhelpsyouachievethebestperformanceofdatabaseforqueriesbyrecommendingtheappropriateindexes？（）

单项选择题 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？（）

All Rights Reserved 版权所有©PP题库网库(pptiku.com)

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064