违法和不良信息举报 联系客服
免费注册 登录

单选题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 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=<nonzero value>; statement

正确答案:C,D

第3题：

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

第4题：

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

第5题：

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

第6题：

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

第7题：

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

第8题：

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

第9题：

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

第10题：

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

更多相关问题
相关内容