多项选择题

A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement……

You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? （）(Choose two.)

A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
B. issuing the ALTER SESSION ENABLE RESUMABLE; statement
C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

<上一题目录下一题>

热门试题

单项选择题You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable spaceallocation for all sessions?（）

A.0
B.10
C.100
D.NULL

多项选择题WhichtwostatementsaretrueregardinganAutomaticStorageManagement（ASM）instance？（）

A. As ASM instance mounts an ASM control file
B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

单项选择题You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）

A. One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
B. One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
D. None of the tables are recovered from the Recycle Bin, and the statement returns an error.

单项选择题You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?（）

A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C. The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.

单项选择题WhichstatementistrueregardingtheVALIDATEDATABASEcommand？（）

A. It checks the database for intrablock corruptions only.
B. It checks for block corruption in the valid backups of the database.
C. It checks the database for both intrablock and interblock corruptions.
D. It checks for only those corrupted blocks that are associated with data files.