多选题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 da

题目
多选题
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

相似考题

1.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.

2. 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

3. 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

4.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.

参考答案和解析
正确答案： A,C
解析： 暂无解析
更多“多选题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 da”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

    正确答案:A,B

  • 第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题：

    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.

    正确答案:A

  • 第6题：

    单选题
    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？（）
    A

    Shut down the instance， copy the control file to the third location and open the database.

    B

    Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.

    C

    Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.

    D

    Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.

    E

    Shut 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.


    正确答案： D
    解析： 暂无解析

  • 第7题：

    多选题
    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 files

    B

    backups that have become obsolete

    C

    copies of the data files and control files

    D

    archived redo log files that have multiple copies in a different archive location and not backed up


    正确答案： B,A
    解析： 暂无解析

  • 第8题：

    多选题
    The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）
    A

    data files

    B

    backup sets

    C

    control files

    D

    archived redo log files


    正确答案： D,A
    解析： 暂无解析

  • 第9题：

    多选题
    Which two statements about Recovery Manager （RMAN） backups are true？ （）
    A

    Online redo log files can be backed up.

    B

    Archived redo log files are backed up.

    C

    Only used data blocks can be backed up as backup sets.

    D

    Only consistent database backups can be performed.

    E

    RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.


    正确答案： C,E
    解析： 暂无解析

  • 第10题：

    多选题
    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.


    正确答案： B,D
    解析： 暂无解析

  • 第11题：

    多选题
    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


    正确答案： D,C
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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.

    正确答案:B,C

  • 第16题：

    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 files
    • B、backups that have become obsolete
    • C、copies of the data files and control files
    • D、archived redo log files that have multiple copies in a different archive location and not backed up

    正确答案:A,B

  • 第17题：

    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.

    正确答案:C

  • 第18题：

    多选题
    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 files

    B

    Backups that have become obsolete

    C

    User managed backups of the data files and control files

    D

    Archived redo log files that have multiple copies in a different archive location and not backed up


    正确答案： A,B
    解析： 暂无解析

  • 第19题：

    多选题
    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


    正确答案： C,A
    解析： 暂无解析

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    多选题
    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


    正确答案： C,B
    解析： 暂无解析

  • 第22题：

    多选题
    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.


    正确答案： B,A
    解析： 暂无解析

  • 第23题：

    多选题
    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.


    正确答案： E,C
    解析： 暂无解析

相关内容