單項(xiàng)選擇題

Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）

A.Set the STATISTICS_LEVEL initialization parameter to ALL.
B.Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
C.Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.

你可能感興趣的試題

單項(xiàng)選擇題

Which is the memory area that is created when a dedicated server process is started， and contains data and control information for that server process？（）

A.SGA
B.PGA
C.Shared Pool
D.Streams Pool

單項(xiàng)選擇題

You execute the following command to audit the database activities：
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；
What is the effect of this command？（）

A.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B.One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C.One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E.One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）

你可能感興趣的試題

Which is the memory area that is created when a dedicated server process is started， and contains data and control information for that server process？（）

You execute the following command to audit the database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）

Which is the memory area that is created when a dedicated server process is started， and contains data and control information for that server process？（）

You execute the following command to audit the database activities：
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；
What is the effect of this command？（）