单项选择题
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature?()
A. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
B. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
C. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
D. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
相关考题
-
单项选择题
YouaremaintainingyourdatabaseinOracle10g.YouareperformingthebackupbyusingtheBACKUPASBACKUPSETcommandattheRMANprompt.WhichfilecannotbebackedupbyusingtheBACKUPASBACKUPSETcommand?()
A.Datafiles
B. Current control file
C. Server parameter file (spfile)
D. Password file -
多项选择题
Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN> COPY DATAFILE 2 TO ’D:\ORACLE\ORA90\MYNEWDB\DA2.DBF’; Which two statements are true regarding the backup created using this command?()
A. The copy of the datafile created is stored in the RMAN repository.
B. The copy of the datafile created can be viewed using the LIST BACKUP command.
C. The copy of the datafile created using this COPY command can be placed only on the disk.
D. The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
E. The copy of the datafile created can be used for recovering the database using the user-managed recovery method. -
单项选择题
YouhaveconfiguredOMFinyourdatabase.YouenabledtheALTERDATABASEENABLEBLOCKCHANGETRACKING;statementtoenabletheblockchangetrackingfeature.Whatinformationwillbewritteninthechangetrackingfile?()
A. the system change number
B. the locations of the redo log files
C. the locations of the datafiles
D. the physical location of all the database changes
