1Z0-053
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE C
题目
You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery
参考答案和解析
相似问题和答案
第1题：
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）
A. Data files that belong to only the root container
B. Data files that belong to the root container and all the pluggable databases (PDBs)
C. Data files that belong to only the root container and PDB$SEED
D. Data files that belong to the root container and all the PDBs excluding PDB$SEED
第2题：
In order to perform Flashback Transaction Query operations， which of these steps are required？（）
- A、 Ensure that database is running with version 10.1 compatibility.
- B、 Enable Flashback Logging.
- C、 Enable Supplemental Logging.
- D、 Ensure that the database is running with version 10.0 compatibility.
- E、 Ensure that the database is in ARCHIVELOG mode.
正确答案:C,D
第3题：
Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）
A. Redo logs
B. Control file
C. The latest backup of only the damaged data file
D. The latest backup of all the data file in the USERS tablespace
E. Temporary files of temporary tablespace
F. Archive Logs since the latest backup to point of failure
第4题：
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）
- A、The backups would be consistent.
- B、The backups would be inconsistent.
- C、The backups would be possible only if the database is running in ARCHIVELOG mode.
- D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
- E、The backups need to be restored and the database has to be recovered in case of a media failure
正确答案:B,C,E
第5题：
Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）
- A、Until last commit
- B、Until the time you perform recovery
- C、Until the time the date file got corrupted
- D、Until the point where the last transaction begun
- E、You cannot recover the SYSTEMtablespaceand must re-create the database.
正确答案:A
第6题：
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）
- A、archival
- B、log writer
- C、database writer
- D、system monitor
- E、process monitor
- F、change tracking writer
正确答案:A,B,C
第7题：
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
第8题：
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)
A. Redo logs
B. Control file
C. The latest backup of only the damaged data file
D. The latest backup of all the data file in the USERS tablespace
E. Temporary files of temporary tablespace
F. Archive Logs since the latest backup to point of failure
第9题：
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
- A、 Enable flashback logging.
- B、 Start the database in the ARCHIVELOG mode.
- C、 Issue the ALTER DATABASE FLASHBACK ON； command.
- D、 Set the FAST_START_MTTR_TARGET initialization parameter.
正确答案:A
第10题：
You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）
- A、You must shut down the database instance to perform the backups.
- B、You must configure the Flash Recovery Area （FRA） for the database.
- C、You can perform complete database backups without closing the database.
- D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
正确答案:C,D