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

Which initialization parameter must you set to enable automa

题目
单选题
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? ()(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

第2题：

You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）

  • A、 0
  • B、 1
  • C、 NONE
  • D、 DEFAULT

正确答案:A

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

To enable resumable space allocation for the instance， which of the following initialization parameters should you set to a nonzero value？（）

  • A、 RESUMABLE_SPACE_TIME
  • B、 RESUMABLE_SPACE
  • C、 RESUMABLE_TIME
  • D、 RESUMABLE_TIMEOUT
  • E、 TIME_RESUMABLE

正确答案:D

第5题：

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

第6题：

You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）

  • A、 Open the database in read-only mode.
  • B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
  • C、 Enable the block change tracking feature.
  • D、 Execute the ALTER DATABASE FLASHBACK ON statement.

正确答案:A,C

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

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

第9题：

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

第10题：

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

更多相关问题
相关内容