多选题Which three statements are true about the stages of database startup？（）AData files and redo log files can be renamed at the MOUNT stage.BControl files are read at the OPEN stage for the location of data files.CControl files are required to bring the database to the NOMOUNT stage.DData files and redo log files are made available to users at the OPEN stage.EData files and online redo log files are checked for consistency while opening the database
多选题
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
参考解析
解析：
暂无解析
相关考题：
You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?() A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
Which two statements are true about Oracle Managed Files (OMF)?() 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.
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
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）A、Flashback log filesB、Backups that have become obsoleteC、User managed backups of the data files and control filesD、Archived redo log files that have multiple copies in a different archive location and not backed up
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
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.
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.
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
After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then 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
Which two 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 online redo log files.
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
You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）A、flashback log filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up
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.
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during 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 datafiles.
单选题You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）AShut down the instance， copy the control file to the third location and open the database.BAbort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.CCopy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.DShut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.EShut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.
多选题You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）AFlashback log filesBBackups that have become obsoleteCUser managed backups of the data files and control filesDArchived redo log files that have multiple copies in a different archive location and not backed up
多选题You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）Aflashback log filesBbackups that have become obsoleteCcopies of the data files and control filesDarchived redo log files that have multiple copies in a different archive location and not backed up
多选题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（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
多选题The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）Adata filesBbackup setsCcontrol filesDarchived redo log files
单选题Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）AThe data files can be recovered till the last committed transaction.BThe data files can be recovered without shutting down the database.CThe data file is taken offline automatically; the database remains open.DThe data files can be recovered to the time of the most recent backup.
多选题Which two statements about Recovery Manager （RMAN） backups are true？ （）AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
多选题Which statements are true about checkpointing（）AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.DIt prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files
多选题Which two statements are true about checkpointing（）AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.DIt prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
多选题Which two statements are true about Oracle Managed Files (OMF)?（）AOMF cannot be used in a database that already has data files created with user-specified directions.BThe file system directions that are specified by OMF parameters are created automatically.COMF can be used with ASM disk groups, as well as with raw devices, for better file management.DOMF automatically creates unique file names for table spaces and control files.EOMF may affect the location of the redo log files and archived log files.
多选题After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
多选题Which two statements are true regarding the database in ARCHIVELOG mode？（）AYou have to shut down the database to perform the backups.BArchiving information is written to the data files and redo log files.CYou can perform complete database backups without closing the database.DOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.EAll the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
单选题Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）AThe data files can be recovered till the last committed transaction.BThe data files can be recovered without shutting down the database.CThe data file is taken offline automatically； the database remains open.DThe data files can be recovered to the time of the most recent backup.