單項(xiàng)選擇題

In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

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

你可能感興趣的試題

單項(xiàng)選擇題

In which situation would you use the Oracle Shared Server configuration？（）

A.when performing export and import using Oracle Data Pump
B.when performing backup and recovery operations using Oracle Recovery Manager
C.when performing batch processing and bulk loading operation in a data warehouse environment
D.in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

單項(xiàng)選擇題

Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command：
LSNRCTL> STOP
What would happen to the sessions that are presently connected to the database instance？（）

A.The sessions are able to perform only queries.
B.The sessions are not affected and continue to function normally.
C.The active transactions are rolled back and the sessions get terminated.
D.The sessions are not allowed to perform any operations till the listener is started.

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

In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

你可能感興趣的試題

In which situation would you use the Oracle Shared Server configuration？（）

Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command： LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance？（）

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

In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

In which situation would you use the Oracle Shared Server configuration？（）

Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command：
LSNRCTL> STOP
What would happen to the sessions that are presently connected to the database instance？（）