單項(xiàng)選擇題

in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impactof this setting（）

A.Optimizer statistics are collected automatically.
B.Only timed operating system （OS） statistics and plan execution statistics are collected.
C.The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

你可能感興趣的試題

單項(xiàng)選擇題

You execute the following command to audit 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 every successful DROP TABLE command executed in the session of SCOTT.
B.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
C.One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
D.One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E.One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

單項(xiàng)選擇題

Which statements listed below describe the data dictionary views（）
1） These are stored in the SYSTEM tablespace.
2） These are the based on the virtual tables.
3） These are owned by the SYS user.
4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE.
5） The V$FIXED_TABLE view can be queried to list the names of these views.

A.1 and 3
B.2， 3， and 5
C.1， 2， and 3
D.2， 3， 4， and 5

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）

你可能感興趣的試題

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

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impactof this setting（）

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