1Z0-032
多选题Which three statements are true about database recovery operations？（）ADamaged or lost data files are restored from backups.BRedo log file entries are used to roll forward the database.CUndo segments are used to roll back any uncommitted transactions.DT
题目
Damaged or lost data files are restored from backups.
Redo log file entries are used to roll forward the database.
Undo segments are used to roll back any uncommitted transactions.
Transactions that were active when the failure occurred are restarted.
Transactions that were active when the failure occurred are automatically committed during the recover procedure.
参考答案和解析
相似问题和答案
第1题：
The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery（）
- A、Inactive and current redo log files are required to accomplish recovery.
- B、Online and archived redo log files are required to accomplish instance recovery.
- C、All redo log entries after the last checkpoint are applied from redo log files to data files.
- D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
正确答案:C
第2题：
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
- A、The online redo log files and archived redo log files are required to accomplish the recovery.
- B、The uncommitted transaction will be committed at the next startup of the database instance.
- C、The uncommitted transaction is rolled back automatically at the next opening of the database.
- D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
正确答案:C
第3题：
Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）
A. It contains data till the last backup
B. It contains all data from target database until the current time
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target database
第4题：
Which three statements are true about the stages of database startup？（）
- A、Data files and redo log files can be renamed at the MOUNT stage.
- B、Control files are read at the OPEN stage for the location of data files.
- C、Control files are required to bring the database to the NOMOUNT stage.
- D、Data files and redo log files are made available to users at the OPEN stage.
- E、Data files and online redo log files are checked for consistency while opening the database
正确答案:A,D,E
第5题：
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
- A、Restore all the data files and open the database
- B、Create the data file and performtablespacerecovery
- C、No need to restore any file， just recover the database
- D、Restore only the system data file and recover the database
- E、Restore only lost date file and performtablespacerecovery
正确答案:A
第6题：
Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）
- A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure.
- B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files.
- C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file.
- D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
正确答案:A
第7题：
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
- A、The online redo log files and online data files are opened.
- B、All the online data file headers are checked for consistency.
- C、Instance recovery is performed before opening the database.
- D、The path and existence of all the log file members are checked
正确答案:A,B
第8题：
A. OMF cannot be used in a database that already has data files created with user-specified directions.
B. The file system directions that are specified by OMF parameters are created automatically.
C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
D. OMF automatically creates unique file names for table spaces and control files.
E. OMF may affect the location of the redo log files and archived log files.
第9题：
Which three statements are true about Flashback Database?（）
- A、Flashback logs are written sequentially, and are archived.
- B、Flashback Database uses a restored control file to recover a database.
- C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
- D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
- E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
- F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
正确答案:B,C,F
第10题：
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？（）
- A、until SCN
- B、until time
- C、until cancel
- D、using backup control file
正确答案:C