单项选择题
You decided to change the location of the flash recovery area. You executed the following command：
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；
Which statement is true？（）
A. The location can be changed only if the flash recovery area is empty.
B. After executing the command， all new flash recovery area files will be created in the new location.
C. The command will generate an error because you cannot change the flash recovery area while the database is open.
D. All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.
相关考题
-
单项选择题
Intheparameterfileofyourproductiondatabase，theCONTROL_FILE_RECORD_KEEP_TIMEparameterissetto31.WhatwouldbetheimpactofthissettingonthebackupthatisbeingperformedbyusingRecoveryManager（RMAN）？（）
A. The backup would be retained on the media for 31 days.
B. The backup would be maintained in the recovery catalog for 31 days.
C. The backup metadata would be retained in the control file for 31 days.
D. The backup metadata would be maintained in the recovery catalog for 31 days.
E. Automatic backups of the control file will be retained in the flash recovery area for 31 days. -
单项选择题
nyourproductiondatabaseyouwanttouseanAutomaticStorageManagement（ASM）instancetomanagethedatabasefiles.Whichoptionwouldyouusetomigratethedatabasefilesfromanon-ASMinstancetoanASMinstance？（）
A. Oracle Migration Assistant
B. Recovery Manager （RMAN）
C. Oracle Data Pump Export and Import
D. conventional Oracle Export and Import
E. operating system utilities to copy the files to the ASM instance -
单项选择题
TheDB_BLOCK_CHECKINGinitializationparameterissettoTRUE.Whatwouldbetheresultofthissettingonthedatablocksbeingwrittentothedatafiles，everytimetheDBWnwrites？（）
A. The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
B. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
C. The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
D. The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
E. The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent.
