单选题You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradat

题目
单选题
You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）
A

They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B

They are created only in the Fast Recovery Area.

C

They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

D

They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

相似考题

1.You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = ‘LOCATION=/disk1/arch‘LOG_ARCHIVE_DEST_2 = ‘LOCATION=/disk2/arch‘LOG_ARCHIVE_DEST_3 = ‘LOACTION=/disk3/arch‘LOG_ARCHIVE_DEST_4 = ‘LOCATION=/disk4/arch MANDATORY‘Identify the statement that correctly describes this setting.（）A. The MANDATORY location must be a flash recovery area.B. The optional destinations may not use the flash recovery area.C. This setting is not allowed because the first destination is not set as MANDATORY.D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

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

3. You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database：  INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB  DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD？（） A、DB_BLOCK_SIZEB、CONTROL_FILESC、LARGE_POOL_SIZED、LOG_ARCHIVE_DESTE、LOG_ARCHIVE_FORMATF、DB_CREATE_FILE_DEST

4.ThedatabaseisrunninginARCHIVELOGmode.Examinetheinitializationparametersandtheirvaluessettoenablearchivingonyourdatabaseserver：LOG_ARCHIVE_FORMAT=arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1=’LOCATION=/disk1/archive’DB_RECOVERY_FILE_DEST=’/u01/oradata’DB_RECOVERY_FILE_DEST_SIZE=20GWhichstatementistrueregardingthearchivedredologfiles（）A.Itwillbecreatedonthelocalfilesystem.B.ItwillbecreatedonlyintheFlashRecoveryArea.C.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandthedefaultlocation$ORACLE_HOME/dbs.D.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandlocationspecifiedbytheDB_RECOVERY_FILE_DESTparameter.

更多“单选题You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradat”相关问题

  • 第1题：

    The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server：  LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc  LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’  DB_RECOVERY_FILE_DEST = ’/u01/oradata’  DB_RECOVERY_FILE_DEST_SIZE = 20G  Which statement is true regarding the archived redo log files（）

    • A、It will be created on the local file system.
    • B、It will be created only in the Flash Recovery Area.
    • C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
    • D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.

    正确答案: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题：

    You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）

    • A、Execute the ALTER DATABASE ARCHIVELOG statement
    • B、Select ARCHIVELOG option in the database control and restart the database to apply the changes.
    • C、Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
    • D、Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.

    正确答案:B,D

  • 第4题：

    You want to set the following Initialization parameters for your database Instance   LOG_ARCHIVE_DEBT_1 = ，，LOCATION=/disk1/arch LOG_ARCHIVE_DBST_2 = ，，LOCATION=/disk2/arch LOC_ARCHIVB DBST_3 = ，，LOCATION=/disk3/arch LOG_ARCHIVE DBST_ = ，，LOCATION=/disk3/arch   Identify the statement that correctly describes this setting.（）  

    • A、 The MANDATORY location must be a flash recovery area.
    • B、 The optional destinations may not use the flash recovery area.
    • C、 This setting is not allowed because the first destination is not set as MANDATORY.
    • D、 The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

    正确答案:D

  • 第5题：

    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

  • 第6题：

    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.

    正确答案:C

  • 第7题：

    单选题
    You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log？（）
    A

    LOG_ARCHIVE_DEST was not set in the parameter file.

    B

    LOG_ARCHIVE_START was not set in the parameter file.

    C

    alter database archivelog； was not executed in MOUNT mode.

    D

    LOG_ARCHIVE_MAX processes were not set in the parameter file.


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

  • 第8题：

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


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

  • 第9题：

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

  • 第10题：

    单选题
    The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server：  LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc  LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’  DB_RECOVERY_FILE_DEST = ’/u01/oradata’  DB_RECOVERY_FILE_DEST_SIZE = 20G  Which statement is true regarding the archived redo log files（）
    A

    It will be created on the local file system.

    B

    It will be created only in the Flash Recovery Area.

    C

    It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.

    D

    It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.


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

  • 第11题：

    单选题
    You want to set the following initialization parameters for your database instance：   LOG_ARCHIVE_DEST_1 = ’LOCATION=/disk1/arch’ LOG_ARCHIVE_DEST_2 = ’LOCATION=/disk2/arch’ LOG_ARCHIVE_DEST_3 = ’LOACTION=/disk3/arch’ LOG_ARCHIVE_DEST_4 = ’LOCATION=/disk4/arch MANDATORY’   Identify the statement that correctly describes this setting.（）
    A

     The MANDATORY location must be a flash recovery area.

    B

     The optional destinations may not use the flash recovery area.

    C

     This setting is not allowed because the first destination is not set as MANDATORY.

    D

     The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.


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

  • 第12题：

    单选题
    You want to set the following Initialization parameters for your database Instance   LOG_ARCHIVE_DEBT_1 = ，，LOCATION=/disk1/arch LOG_ARCHIVE_DBST_2 = ，，LOCATION=/disk2/arch LOC_ARCHIVB DBST_3 = ，，LOCATION=/disk3/arch LOG_ARCHIVE DBST_ = ，，LOCATION=/disk3/arch   Identify the statement that correctly describes this setting.（）
    A

     The MANDATORY location must be a flash recovery area.

    B

     The optional destinations may not use the flash recovery area.

    C

     This setting is not allowed because the first destination is not set as MANDATORY.

    D

     The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.


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

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

    You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）

    • A、They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
    • B、They are created only in the Fast Recovery Area.
    • C、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
    • D、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

    正确答案:B

  • 第15题：

    You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' Identify the statement that correctly describes this setting.（）

    • A、The MANDATORY location must be a flash recovery area.
    • B、The optional destinations may not use the flash recovery area.
    • C、This setting is not allowed because the first destination is not set as MANDATORY.
    • D、The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

    正确答案:D

  • 第16题：

    Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode？（） 

    • A、 Setting the FAST_START_MTTR_TARGET to set the mean time to recover
    • B、 Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
    • C、 Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
    • D、 Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

    正确答案:C,D

  • 第17题：

    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）

    • A、 The archived redo logs are stored in an operating system-dependent location.
    • B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
    • C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
    • D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

    正确答案:C

  • 第18题：

    You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log？（）

    • A、LOG_ARCHIVE_DEST was not set in the parameter file.
    • B、LOG_ARCHIVE_START was not set in the parameter file.
    • C、alter database archivelog； was not executed in MOUNT mode.
    • D、LOG_ARCHIVE_MAX processes were not set in the parameter file.

    正确答案:B

  • 第19题：

    单选题
    You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）
    A

    They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

    B

    They are created only in the Fast Recovery Area.

    C

    They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

    D

    They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.


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

  • 第20题：

    单选题
    You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD？（）
    A

     LARGE_POOL_SIZE

    B

     DB_CREATE_FILE_DEST

    C

     LOG_ARCHIVE_DEST

    D

     CONTROL_FILES

    E

     LOG_ARCHIVE_FORMAT

    F

     DB_BLOCK_SIZE


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

  • 第21题：

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

  • 第22题：

    单选题
    You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?（）
    A

    They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

    B

    They are created only in the Fast Recovery Area.

    C

    They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

    D

    They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.


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

  • 第23题：

    单选题
    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）
    A

     The archived redo logs are stored in an operating system-dependent location.

    B

     The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.

    C

     The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.

    D

     The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.


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

  • 第24题：

    单选题
    You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database：  INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB  DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD？（）
    A

    DB_BLOCK_SIZE

    B

    CONTROL_FILES

    C

    LARGE_POOL_SIZE

    D

    LOG_ARCHIVE_DEST

    E

    LOG_ARCHIVE_FORMAT

    F

    DB_CREATE_FILE_DEST


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

相关内容