多项选择题

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used？（）

A. fixed tables
B. heap tables
C. external tables
D. temporary tables
E. Index-Organized Tables （IOTs）

点击查看答案

上一题目录下一题

相关考题

多项选择题

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.