单选题Your archive-log destination directory runs out of space. What is the impact of this on the database?（）A None. The database will switch over to the stand-by archive-log destination directory. B A warning message will be written to the alert log of the 

题目
单选题
Your archive-log destination directory runs out of space. What is the impact of this on the database?（）
A

None. The database will switch over to the stand-by archive-log destination directory. 

B

A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced. 

C

The database will shut down, and will not restart until you correct the out-of-space situation. 

D

The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally. 

E

Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.

相似考题

1.How many individual archive－log destination directories are supported by Oracle Database11g?()A.7B.1C.10D.11E.21

2.Your archive-log destination directory runs out of space. What is the impact of this on the database？（）  A、 None. The database will switch over to the stand-by archive-log destination directory.B、 A warning message will be written to the alert log of the database，but no adverse impacts to the database will be experienced.C、 The database will shut down，and will not restart until you correct the out-of-space situation.D、 The database will continue to try to write to the archive-log destination directory for one hour. After one hour，the database will shut down normally.E、 Once Oracle has cycled through all online redo logs，it will stop processing any DML or DDL until the out-of-space condition is corrected.

3. You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）  A、 The online redo log file Is not allowed to be overwritten.B、 The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.C、 The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.D、 The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

4.You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）A、 The log sequence for the database will restart from 1.B、 The log sequence number will be written to the control file.C、 The log sequence number will be written to the datafile headers.D、 The log sequence number will be written to the initialization parameter file.

更多“单选题Your archive-log destination directory runs out of space. What is the impact of this on the database?（）A None. The database will switch over to the stand-by archive-log destination directory. B A warning message will be written to the alert log of the ”相关问题

  • 第1题：

    You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）

    • A、Enable the flash recovery area and specify it as the archived redo log destination.
    • B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
    • C、Enable the flash recovery area but do not specify it as the archived redo log destination.
    • D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode

    正确答案:A

  • 第2题：

    You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

    • A、Archiving will be disabled because the destination for the redo log files is missing.
    • B、The database instance will shut down and the error details will be logged in the alert log file.
    • C、Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
    • D、Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

    正确答案:C

  • 第3题：

    How many individual archive-log destination directories are supported by Oracle Database11g?（）

    • A、7
    • B、1
    • C、10
    • D、11
    • E、21

    正确答案:C

  • 第4题：

    In your database， the Log Writer （LGWR）  process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）

    • A、The database instance aborts.
    • B、The database operation temporarily halts till the member becomes available.
    • C、Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
    • D、The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
    • E、The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

    正确答案:C,D

  • 第5题：

    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

  • 第6题：

    单选题
    You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）
    A

     The log sequence for the database will restart from 1.

    B

     The log sequence number will be written to the control file.

    C

     The log sequence number will be written to the datafile headers.

    D

     The log sequence number will be written to the initialization parameter file.


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

  • 第7题：

    单选题
    How many individual archive-log destination directories are supported by Oracle Database11g?（）
    A

    7 

    B

    1 

    C

    10 

    D

    11 

    E

    21


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

  • 第8题：

    多选题
    Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）
    A

    The destination must be global only.

    B

    A maximum of five destinations can be assigned.

    C

    A maximum of ten different destinations can be assigned.

    D

    All the destinations are determined by the server automatically.

    E

    The destination may be local or remote for a Standby Database.

    F

    The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.


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

  • 第9题：

    单选题
    You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）
    A

     The online redo log file Is not allowed to be overwritten.

    B

     The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.

    C

     The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.

    D

     The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.


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

  • 第10题：

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

  • 第11题：

    单选题
    When you create a backup control file， where is the resulting file written to？（）
    A

     The database user dump destination directory

    B

     The database diagnostic destination directory

    C

     To $ORACLE_HOME/rdbms

    D

     To $ORACLE_HOME/admin

    E

     To the directory and filename you specify in the command


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

  • 第12题：

    单选题
    Your archive-log destination directory runs out of space. What is the impact of this on the database？（）
    A

     None. The database will switch over to the stand-by archive-log destination directory.

    B

     A warning message will be written to the alert log of the database，but no adverse impacts to the database will be experienced.

    C

     The database will shut down，and will not restart until you correct the out-of-space situation.

    D

     The database will continue to try to write to the archive-log destination directory for one hour. After one hour，the database will shut down normally.

    E

     Once Oracle has cycled through all online redo logs，it will stop processing any DML or DDL until the out-of-space condition is corrected.


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

  • 第13题：

    Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

    • A、The destination must be global only.
    • B、A maximum of five destinations can be assigned.
    • C、A maximum of ten different destinations can be assigned.
    • D、All the destinations are determined by the server automatically.
    • E、The destination may be local or remote for a Standby Database.
    • F、The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

    正确答案:C,E

  • 第14题：

    How many individual archive-log destination directories are supported by Oracle Database11g?（）

    • A、7 
    • B、1 
    • C、10 
    • D、11 
    • E、21

    正确答案:C

  • 第15题：

    Your archive-log destination directory runs out of space. What is the impact of this on the database?（）

    • A、None. The database will switch over to the stand-by archive-log destination directory. 
    • B、A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced. 
    • C、The database will shut down, and will not restart until you correct the out-of-space situation. 
    • D、The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally. 
    • E、Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.

    正确答案:E

  • 第16题：

    When you create a backup control file， where is the resulting file written to？（）  

    • A、 The database user dump destination directory
    • B、 The database diagnostic destination directory
    • C、 To $ORACLE_HOME/rdbms
    • D、 To $ORACLE_HOME/admin
    • E、 To the directory and filename you specify in the command

    正确答案:E

  • 第17题：

    多选题
    In your database， the Log Writer （LGWR）  process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）
    A

    The database instance aborts.

    B

    The database operation temporarily halts till the member becomes available.

    C

    Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.

    D

    The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.

    E

    The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.


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

  • 第18题：

    单选题
    You are working on the Certkiller database.  What is the default name of the alert log file in this database？（）
    A

    alert_ Certkiller .log

    B

    alertlog_ Certkiller .log

    C

    alert_log_ Certkiller .log

    D

    Certkiller _alert_log.log

    E

    log_alert_： Certkiller .log

    F

    trace_alert_ Certkiller .log


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

  • 第19题：

    单选题
    What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）
    A

    MTTR Advisor would be disabled.

    B

    Redo Log Advisor would be disabled.

    C

    Automatic tuning of checkpoint would be disabled.

    D

    Checkpoint information would not be written to the alert log file.


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

  • 第20题：

    单选题
    You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.  What will be the implications on the archiving and the location of archive redo log files（）
    A

    Archiving will be disabled because the destination for the redo log files is missing.

    B

    The database instance will shut down and the error details will be logged in the alert log file.

    C

    Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.

    D

    Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.


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

  • 第21题：

    单选题
    You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）
    A

    Enable the flash recovery area and specify it as the archived redo log destination.

    B

    Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

    C

    Enable the flash recovery area but do not specify it as the archived redo log destination.

    D

    Disable the flash recovery area and start the database instance in NOARCHIVELOG mode


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

  • 第22题：

    单选题
    You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）
    A

     Enable the flash recovery area and specify it as the archived redo log destination.

    B

     Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

    C

     Enable the flash recovery area but do not specify it as the archived redo log destination. 

    D

     Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.


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

  • 第23题：

    单选题
    How many individual archive-log destination directories are supported by Oracle Database11g?（）
    A

    7

    B

    1

    C

    10

    D

    11

    E

    21


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

相关内容