单选题Which initialization parameter must you set to enable automatic archiving？ （）A LOG_ARCHIVE_DESTB LOG_ARCHIVE_STARTC LOG_ARCHIVE_FORMATD LOG_ARCHIVE_MAX_PROCESSES

题目
单选题
Which initialization parameter must you set to enable automatic archiving？ （）
A

LOG_ARCHIVE_DEST

B

LOG_ARCHIVE_START

C

LOG_ARCHIVE_FORMAT

D

LOG_ARCHIVE_MAX_PROCESSES

相似考题

1.You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

2.You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?()A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement

3.You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? ()(Choose two.)A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

4.Which two initialization parameters would you set to enable Automatic Shared Memory Management?()A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALL

参考答案和解析
正确答案： D
解析： 暂无解析
更多“单选题Which initialization parameter must you set to enable automatic archiving？ （）A LOG_ARCHIVE_DESTB LOG_ARCHIVE_STARTC LOG_ARCHIVE_FORMATD LOG_ARCHIVE_MAX_PROCESSES”相关问题

  • 第1题：

    You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）

    • A、issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
    • B、issuing the ALTER SESSION ENABLE RESUMABLE; statement
    • C、modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
    • D、issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement

    正确答案:C,D

  • 第2题：

    You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（） 

    • A、 issuing the ALTER SYSTEM ENABLE RESUMABLE；statement
    • B、 issuing the ALTER SESSION ENABLE RESUMABLE；statement
    • C、 modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
    • D、 issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement

    正确答案:C,D

  • 第3题：

    You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? （）(Choose two.)

    • A、issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
    • B、issuing the ALTER SESSION ENABLE RESUMABLE; statement
    • C、modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
    • D、issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

    正确答案:C,D

  • 第4题：

    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

    • A、Set MEMORY_TARGET to zero
    • B、Set the STATISTICS_LEVEL parameter to BASIC
    • C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
    • D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value

    正确答案:D

  • 第5题：

    You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）

    • A、The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
    • B、The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
    • C、Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.
    • D、The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

    正确答案:B,D

  • 第6题：

    You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）

    • A、 INSTANCE_TYPE
    • B、 DB_UNIQUE_NAME
    • C、 ASM_DISKSTRING
    • D、 ASM_POWER_LIMIT

    正确答案:A

  • 第7题：

    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）

    • A、 only the INSTANCE_TYPE initialization parameter is set to an invalid value
    • B、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
    • C、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
    • D、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

    正确答案:D

  • 第8题：

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

  • 第9题：

    单选题
    You have included the following parameter settings in your SPFILE://    SGA_MAX_SIZE=8G   SGA_TARGET=6G   DB_CACHE_SIZE=2G   SHARED_POOL_SIZE=1G   LOG_BUFFER=64M   DB_KEEP_CACHE_SIZE=960M   Which statement is true if you modify the SGA_TARGET initialization parameter？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value greater than 8G

    B

     The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G

    C

     The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G

    D

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M 

    E

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M


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

  • 第10题：

    单选题
    Which statement about Automatic Memory Management with Oracle 11g is true？（）
    A

     You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.

    B

     Oracle can reallocate memory between the SGA and PGA automatically as needed.

    C

     To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

    D

     You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.


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

  • 第11题：

    单选题
    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）
    A

     Set MEMORY_TARGET to zero

    B

     Set the STATISTICS_LEVEL parameter to BASIC

    C

     Set the WORKAREA_SIZE_POLICY parameter to MANUAL

    D

     Set the PGA_AGGREGATE_TARGET parameter to nonzero value


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

  • 第12题：

    多选题
    You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）
    A

    Set the UNDO_RETENTION parameter to AUTO.

    B

    Create an initial undo segment in undotablespace.

    C

    Set the UNDO_RETENTION parameter to 900 or more

    D

    Set the initialization parameter UNDO_MANAGEMENT to AUTO

    E

    Set the UNDO_MANAGEMENT parameter to the name of an undotablespace


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

  • 第13题：

    Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）

    • A、 set SHARED_POOL_SIZE to zero
    • B、 set STATISTICS_LEVEL to BASIC
    • C、 set SGA_TARGET to a non-zero value
    • D、 set DB_CACHE_SIZE to a non-zero value
    • E、 set STATISTICS_LEVEL to TYPICAL or ALL

    正确答案:A,C

  • 第14题：

    You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

    • A、Set the UNDO_RETENTION parameter to AUTO.
    • B、Create an initial undo segment in undotablespace.
    • C、Set the UNDO_RETENTION parameter to 900 or more
    • D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
    • E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

    正确答案:D,E

  • 第15题：

    In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）

    • A、The STATISTICS_LEVEL initialization parameter is set to BASIC
    • B、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
    • C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
    • D、The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
    • E、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

    正确答案:A

  • 第16题：

    Which initialization parameter must you set to enable automatic archiving？ （）

    • A、LOG_ARCHIVE_DEST
    • B、LOG_ARCHIVE_START
    • C、LOG_ARCHIVE_FORMAT
    • D、LOG_ARCHIVE_MAX_PROCESSES

    正确答案:B

  • 第17题：

    Which of the following would you use to enable automatic media recovery for a database？（）

    • A、SET AUTORECOVERY ON
    • B、SET RECOVERY ON
    • C、SET AUTO ON
    • D、You cannot enable automatic media recovery.

    正确答案:A

  • 第18题：

    You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）

    • A、Set the UNDO_RETENTION parameter to 900 or more.
    • B、Create an initial undo segment in the undo tablespace.
    • C、Enable the retention guarantee for the undo tablespace.
    • D、Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
    • E、Set the UNDO_MANAGEMENT initialization parameter to AUTO.

    正确答案:D,E

  • 第19题：

    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

  • 第20题：

    多选题
    You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）
    A

    The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.

    B

    The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.

    C

    Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.

    D

    The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.


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

  • 第21题：

    单选题
    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）
    A

     only the INSTANCE_TYPE initialization parameter is set to an invalid value

    B

     only the ASM_POWER_LIMIT initialization parameter is set to an invalid value

    C

     only the LARGE_POOL_SIZE initialization parameter is set to an invalid value

    D

     both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values


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

  • 第22题：

    单选题
    You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）
    A

     INSTANCE_TYPE

    B

     DB_UNIQUE_NAME

    C

     ASM_DISKSTRING

    D

     ASM_POWER_LIMIT


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

  • 第23题：

    单选题
    In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）
    A

    The STATISTICS_LEVEL initialization parameter is set to BASIC

    B

    The PGA_AGGREGATE_TARGET initialization parameter is set to zero.

    C

    The SGA_MAX_SIZE initialization parameter is set to less than 20 GB

    D

    The DB_CACHE_SIZE initialization parameter is set to less than 5 GB

    E

    The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.


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

相关内容