多項選擇題

Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）

A. set SHARED_POOL_SIZE to zero
B. set STATISTICS_LEVEL to BASIC
C. set SGA_TARGET to a non-zero value
D. set DB_CACHE_SIZE to a non-zero value
E. set STATISTICS_LEVEL to TYPICAL or ALL

你可能感興趣的試題

單項選擇題

An online tablespace，TEST_TBS，is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace.
What could be the reason，if the TEST_TBS tablespace does not include autoextensible data files？（）

A. TEST_TBS is a small file tablespace.
B. TEST_TBS is a bigfile tablespace （BFT）.
C. TEST_TBS is the default temporary tablespace.
D. TEST_TBS is a dictionary-managed tablespace.

單項選擇題

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.
Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）

A. The archived redo log files will be overwritten.
B. The archived redo log files are deleted automatically.
C. The archived redo log files should be moved to some other location.
D. The archived redo log files are still maintained because the file names are unique.

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

Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）

你可能感興趣的試題

An online tablespace，TEST_TBS，is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason，if the TEST_TBS tablespace does not include autoextensible data files？（）

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’. Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）

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

Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）

An online tablespace，TEST_TBS，is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace.
What could be the reason，if the TEST_TBS tablespace does not include autoextensible data files？（）

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.
Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）