black

1z0-043

登录

单项选择题

You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set?()

A. DBMS_WORKLOAD_REPOSITORY
B. DBMS_RESOURCE_MANAGER
C. DBMS_SQLTUNE
D. DBMS_ADVISOR

相关考题

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

单项选择题 William specified the following initialization parameter settings in the pfile:   BACKGROUND_DUMP_DEST = ’u01\oradata\dir_A’   USER_DUMP_DEST = ’u01\oradata\dir_B’   DB_CREATE_FILE_DEST = ’u01\oradata\dir_C’   DB_CREATE_ONLINE_LOG_DEST_n = ’u01\oradata\dir_D’   William enabled the change-tracking feature because he does not want to scan the entire datafile during backup. What is the default storage location for the change tracking file?()

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

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064