多项选择题

You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（）

A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager

<上一题目录下一题>

热门试题

多项选择题Whichoptionswouldyouconsiderwhileconfiguringaflashrecoveryareafastrecoveryareain11gRelease2foryourproductiondatabasethatisrunninginARCHIVELOGmode？（）

A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

多项选择题Toenablefasterincrementalbackups，youenabledblockchangetrackingforthedatabase.Whichtwostatementsaretrueabouttheblockchangetrackingfile？（）

A. Multiple change tracking files can be created for a database.
B. The change tracking file must be created after the first level 0 backup.
C. RMAN does not support backup and recovery of the change tracking file.
D. The database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.

单项选择题View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation： RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； } What is the multiplexing level in the preceding backup process？（）

A. 4
B. 8
C. 7
D. 0

单项选择题You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this： 1. Set the retention target： SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320； 2. Enable Flashback Database： SQL> ALTER DATABASE FLASHBACK ON； 3. Mount the database： SQL> STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance： SQL> SHUTDOWN IMMEDIATE 5. Open the database： SQL> ALTER DATABASE OPEN； Choose the correct sequence.（）

A. 4， 1， 3， 2， 5
B. 4， 3， 1， 2， 5
C. 2， 4， 3， 5， 1
D. 4， 2， 5， 3， 1

多项选择题Whichtwocommandsnevertriggeranimplicitrebalancingwithinthediskgroup？（）

A. ALTER DISKGROUP misc MOUNT
B. ALTER DISKGROUP misc DROP DISK misc2
C. ALTER DISKGROUP misc CHECK ALL NOREPAIR
D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m
E. ALTER DISKGROUP dgroupA ADD DISK ’/devices/A*’