data files
control file
password file
online redo log files
initialization parameter file
第1题:
Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?()
第2题:
ASM supports all but which of the following file types?()
第3题:
The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()
第4题:
Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager (RMAN)()
第5题:
When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?()
第6题:
Alert log file
Archived redo log files
Control file autobackups
Server Parameter file (SPFILE)
Recovery Manager (RMAN) backup piece
第7题:
any control file
any archive log file
one of the redo log members
loss of the initialization parameter file
any data file belonging to the default permanent tablespac
第8题:
The redo log file should belong to an active group.
The redo log file should belong to an inactive group.
The redo log file should belong to the current group.
The redo log file can be dropped only if all the transactions are stopped.
Before a redo log file is dropped, it should be deleted from the operating system (OS).
第9题:
Alert log file
Archived redo log files
Control file autobackups
Server Parameter file (SPFILE)
Recovery Manager (RMAN) backup piece
第10题:
control file
all datafiles
password file
online redo log file
archive redo log file
server parameter file
only the SYSTEM datafile
第11题:
Data files
Control files
Parameter file
Online redo log files
Server parameter file
第12题:
Back up the Flash Recovery Area.
Decrease the retention time for the database backup and flashback log files.
Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS)commands.
Manually delete all the expired backup sets from the Flash Recovery Area by using operating system(OS) commands.
第13题:
You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)
第14题:
Which three types of files can be automatically placed in the flash recovery area fast recovery area in 11g Release 2?()
第15题:
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()
第16题:
Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down?()
第17题:
The backup contains data files, the server parameter file,and the control file even if the control file autobackup is disabled.
The KEEP option overrides the configured retention policy.
The backup contains only data files and archived redo log files.
The KEEP option is an attribute of an individual backup piece.
第18题:
data file
password file
archivelog file
temporary file
online redo log file
the current control file
the tnsnames.ora file
current server parameter file
第19题:
ABORT
NORMAL
IMMEDIATE
TRANSACTIONAL
第20题:
data files
control file
password file
online redo log files
initialization parameter file
第21题:
data files
control files
tablespaces
password file
parameter file
whole database
flashback log file
archived log files
change tracking file
第22题:
data files
control files
parameter file
online redo log files
server parameter file
第23题:
The KEEP option overrides the configured retention policy
The KEEP option is an attribute of an individual backup piece
The backup contains only data files and archived redo log files
The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled
第24题:
data file
password file
archivelog file
temporary file
online redo log file
the current control file
the tnsnames.ora file
current server parameter file