单选题Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）A any control fileB any archive log fileC one of the redo log membersD loss of the initia

题目
单选题
Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）
A

any control file

B

any archive log file

C

one of the redo log members

D

loss of the initialization parameter file

E

any data file belonging to the default permanent tablespac

相似考题

1.The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? ()(Choose two)A. Control filesB. Password filesC. Inactive online redo log fileD. Archived log files required to perform recoveryE. Newly created tablespace which is not backed up

2.The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 Control filesB、 Password filesC、 Inactive online redo log fileD、 Archived log files required to perform recoveryE、 Newly created tablespace which is not backed up

3.In which two cases would you perform only consistent backup？（）A、You are working on a database where downtime is not tolerated.B、You are working on a database where downtime can be tolerated.C、You are working on a database that operates in ARCHIVELOG mode.D、You are working on a database that operates in NOARCHIVELOG mode.E、You are working on a database where all the tablespaces are locally managed.F、You are working on a database where control files and redo log files are multiplexed.G、You are working on a database where control files and redo log files are not multiplexed.

4. In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？（）A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

参考答案和解析
正确答案： A
解析： 暂无解析
更多“Your database is having two control files， three redo log fi”相关问题

  • 第1题：

    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

    • A、the V$LOG view
    • B、the V$DBFILE view
    • C、the V$LOGFILE view
    • D、the V$INSTANCE_RECOVERY view
    • E、Oracle Enterprise Manager Database Control

    正确答案:D,E

  • 第2题：

    Which type of database file is spread across all disks in a disk group？（）

    • A、 All types of files are spread across all disks in the disk group.
    • B、 Datafiles
    • C、 Redo log files
    • D、 Archived redo log files
    • E、 Control files

    正确答案:A

  • 第3题：

    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

  • 第4题：

    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

    • A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
    • B、 Before the instance starts， you receive an error about the missing redo log files of a group.
    • C、 The instance starts and the database opens with an error message written to the alert log file.
    • D、 The instance starts and the database opens because two redo log groups still exist.
    • E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

    正确答案:A

  • 第5题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)

    • A、Creating the control file for the duplicate database
    • B、Restoring the target data files to the duplicate database
    • C、Performing complete recovery using all available backups
    • D、Generating a new, unique DBID for the duplicate database
    • E、Copying the online redo log files from the target database to the duplicate database

    正确答案:C,E

  • 第6题：

    You work as a database administrator for Certkiller .com. 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 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
    解析： 暂无解析

  • 第8题：

    单选题
    Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）
    A

     The database will operate normally without generating any redo.

    B

     The database will hang， and you must shut down and restart the instance.

    C

     The database will crash， and you must recover the database from the point of failure.

    D

     The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.


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

  • 第9题：

    单选题
    If you create your database using Oracle Managed Files （OMF）， what is true？（）
    A

    You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 

    B

    You must define directories for two online redo log groups and three copies of the control file. 

    C

    If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 

    D

    You must use only OMF data files when adding new tablespaces or data files to your database in the future.


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

  • 第10题：

    多选题
    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,B
    解析： 暂无解析

  • 第11题：

    单选题
    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）
    A

    Open the database in NORMAL mode

    B

    Open the database in read-only mode

    C

    Open the database in RESTRICTED mode

    D

    Open the database with the RESETLOGS option


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

  • 第12题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第13题：

    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

    • A、renaming the control files
    • B、dropping a user in your database
    • C、enabling or disabling redo log archiving
    • D、dropping a tablespace in your database
    • E、re-creating the control files， after you lost all the control files in your database

    正确答案:C

  • 第14题：

    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

  • 第15题：

    Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）

    • A、data files
    • B、control files
    • C、parameter file
    • D、online redo log files
    • E、server parameter file

    正确答案:B,E

  • 第16题：

    Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）

    • A、Data files
    • B、Control files
    • C、Parameter file
    • D、Online redo log files
    • E、Server parameter file

    正确答案:B,E

  • 第17题：

    Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）

    • A、any control file
    • B、any archive log file
    • C、one of the redo log members
    • D、loss of the initialization parameter file
    • E、any data file belonging to the default permanent tablespac

    正确答案:A

  • 第18题：

    单选题
    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
    A

    renaming the control files

    B

    dropping a user in your database

    C

    enabling or disabling redo log archiving

    D

    dropping a tablespace in your database

    E

    re-creating the control files， after you lost all the control files in your database


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

  • 第19题：

    单选题
    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）
    A

     The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.

    B

     Before the instance starts， you receive an error about the missing redo log files of a group.

    C

     The instance starts and the database opens with an error message written to the alert log file.

    D

     The instance starts and the database opens because two redo log groups still exist.

    E

     The instance starts and the database opens， but every attempt to write to redo log files fails with an error.


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

  • 第20题：

    多选题
    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？（）
    A

    increase the size of the redo log buffer

    B

    increase the number of redo log groups

    C

    increase the number of log writer processes

    D

    increase the number of ARCn processes

    E

    change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location


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

  • 第21题：

    单选题
    Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）
    A

    any control file

    B

    any archive log file

    C

    one of the redo log members

    D

    loss of the initialization parameter file

    E

    any data file belonging to the default permanent tablespac


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

  • 第22题：

    单选题
    Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）
    A

    Restore the latest whole backup, perform complete recovery, and open the database normally

    B

    Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option

    C

    Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option

    D

    Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option


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

  • 第23题：

    单选题
    You work as a database administrator for Certkiller .com. 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.


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

  • 第24题：

    多选题
    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
    A

    the V$LOG view

    B

    the V$DBFILE view

    C

    the V$LOGFILE view

    D

    the V$INSTANCE_RECOVERY view

    E

    Oracle Enterprise Manager Database Control


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

相关内容