單項(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.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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

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