Oracle认证考试
Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）A、The data files can be recovered till the last committed transaction.B、The data files can be recovered without shutting down the database.C、The data file is taken o
题目
Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）
- A、The data files can be recovered till the last committed transaction.
- B、The data files can be recovered without shutting down the database.
- C、The data file is taken offline automatically； the database remains open.
- D、The data files can be recovered to the time of the most recent backup.
相似问题和答案
第1题：
Which two statements correctly describe the relation between a data file and the logical databasestructures（）
- A、An extent cannot spread across data files.
- B、A segment cannot spread across data files.
- C、A data file can belong to only one tablespace.
- D、A data file can have only one segment created in it.
- E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.
正确答案:A,C
第2题：
Which statements are true about checkpointing（）
- A、The checkpoint frequency decreases with the smaller redo log file size.
- B、It ensures that all committed data is written to the data files during normal shutdown.
- C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.
- D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files
正确答案:B,C
第3题：
You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）
A. The backup will terminate because the FORMAT clause was not configured for the channel
B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第4题：
Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）
- A、The data files can be recovered till the last committed transaction.
- B、The data files can be recovered without shutting down the database.
- C、The data file is taken offline automatically; the database remains open.
- D、The data files can be recovered to the time of the most recent backup.
正确答案:A
第5题：
Data files of which three tablespaces can be recovered by performing an openrecovery？（）
- A、TEMP
- B、UNDO
- C、INDEX
- D、SYSAUX
- E、SYSTEM
正确答案:A,C,D
第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题：
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
- A、The instance aborts.
- B、The database cannot be recovered.
- C、The database can be recovered by restoring the control files from the backup.
- D、The database remains opened and you have to shut it down with the ABORT option.
- E、The database can be restored till the point of the last closed whole database backup.
正确答案:A,E
第8题：
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
第9题：
Which two statements are true regarding the database in ARCHIVELOG mode？（）
- A、You have to shut down the database to perform the backups.
- B、Archiving information is written to the data files and redo log files.
- C、You can perform complete database backups without closing the database.
- D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
- E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
正确答案:C,E
第10题：
You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
- A、You can perform consistent backups only.
- B、You can perform a complete database backup without shutting down the database instance.
- C、You can back up data files only when all data files have the same SCN recorded in the control file.
- D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
正确答案:B,D