多项选择题
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task， you issued the following command：
SQL> ALTER TABLESPACE hi_data BEGIN BACKUP；
Which two statements are true in this scenario？（）
A. No transaction on the tablespace is allowed but you can perform queries.
B. The tablespace will automatically come out of backup mode when the file copy is complete.
C. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
D. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
相关考题
-
多项选择题
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
