多项选择题
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. -
单项选择题
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）
A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
