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

多选题Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）ASYNC or ASYNC to identify the network transmission mode.BLGWR or ARCH to identify the primary database pro

题目
多选题
Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）
A

SYNC or ASYNC to identify the network transmission mode.

B

LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.

C

AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.

D

PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.

参考答案和解析
正确答案： C,B
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

In an environment that includes both a Master Domain Manager （MDM）  and Backup Master Domain Manger （BMDM），  which two options are  appropriate for the location of the database？ （）

  • A、 local database installed on the MDM only
  • B、 live local database installed on the BMDM only
  • C、 single database on a clustered machine remote from the MDM and BMDM
  • D、 live database installed on a single Fault Tolerant Agent within IBM  Tivoli Workload Scheduler network
  • E、 live database on MDM and High Availability Disaster Recovery/Data  Guard standby database on BMDM

正确答案:C,E

第2题：

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

  • A、To store the backup information of multiple database
  • B、To restrict the amount of space that is used by the backups
  • C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
  • D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

正确答案:A,D

第3题：

The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?()

A. The Oracle database will perform block checking for the index blocks only

B. The Oracle database will not perform block checking for any of the data blocks

C. The Oracle database will perform block checking for the default permanent tablespace only

D. The Oracle database will perform block checking for the data blocks in all user tablespaces

E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only


参考答案：E

第4题：

Which two file types must be included in a closed database backup taken with operating system commands？（）

  • A、data files
  • B、control file
  • C、password file
  • D、online redo log files
  • E、initialization parameter file

正确答案:A,B

第5题：

Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

  • A、 redo logs
  • B、 control file
  • C、 temporary files of temporary tablespace
  • D、 the latest backup of only the damaged data file
  • E、 the latest backup of all the data files In the USERS tablespace

正确答案:A,B,D

第6题：

Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）

  • A、SYNC or ASYNC to identify the network transmission mode. 
  • B、LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby. 
  • C、AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously. 
  • D、PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.

正确答案:A,B,C

第7题：

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

  • A、 The database will not start.
  • B、 The database will start but will not retain the undo data in the undo segment.
  • C、 The database will start， and the undo segment will contain the undo data for at least one hour.
  • D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

正确答案:D

第8题：

What are three purposes of the RMAN “FROM” clause?()

A. to support PUSH-based active database duplication

B. to support synchronization of a standby database with the primary database in a Data environment

C. To support PULL-based active database duplication

D. To support file restores over the network in a Data Guard environment

E. To support file recovery over the network in a Data Guard environment


参考答案：B, C, E

第9题：

The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  

  • A、 The Oracle database will perform block checking for the index blocks only
  • B、 The Oracle database will not perform block checking for any of the data blocks
  • C、 The Oracle database will perform block checking for the default permanent tablespace only
  • D、 The Oracle database will perform block checking for the data blocks in all user tablespaces
  • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

正确答案:E

第10题：

What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）

  • A、The standby database is protected against write operations. 
  • B、The primary database is protected against write operations. 
  • C、The primary database is protected against data loss and data divergence. 
  • D、The standby database is protected against data loss and data divergence. 

正确答案:C

更多相关问题
相关内容