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

相似考题

1.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 onlyB. The Oracle database will not perform block checking for any of the data blocksC. The Oracle database will perform block checking for the default permanent tablespace onlyD. The Oracle database will perform block checking for the data blocks in all user tablespacesE. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

2. 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 onlyB、 live local database installed on the BMDM onlyC、 single database on a clustered machine remote from the MDM and BMDMD、 live database installed on a single Fault Tolerant Agent within IBM  Tivoli Workload Scheduler networkE、 live database on MDM and High Availability Disaster Recovery/Data  Guard standby database on BMDM

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

4.What are three purposes of the RMAN “FROM” clause?()A. to support PUSH-based active database duplicationB. to support synchronization of a standby database with the primary database in a Data environmentC. To support PULL-based active database duplicationD. To support file restores over the network in a Data Guard environmentE. To support file recovery over the network in a Data Guard environment

更多“多选题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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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. （）(Choose two.)

    • 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

  • 第5题：

    Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）

    • A、only the control file, the current SPFILE, and data files
    • B、only the current SPFILE and data files if autobackup is disabled
    • C、only the data files and the archived redo logs
    • D、the control file, current SPFILE file, data files, and archived redo logs

    正确答案:D

  • 第6题：

    Which two database operations can be performed at the MOUNT stage of database startup？（）

    • A、renaming of data files
    • B、dropping the database user
    • C、renaming of control files
    • D、multiplexing of control files
    • E、configuring the database in ARCHIVELOG mode

    正确答案:A,E

  • 第7题：

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


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

  • 第8题：

    多选题
    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


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

  • 第9题：

    单选题
    Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）
    A

    any control file

    B

    any archive log file

    C

    one of the redo log members

    D

    loss of the initialization parameter file

    E

    any data file belonging to the default permanent tablespac


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

  • 第10题：

    多选题
    Which two database operations can be performed at the MOUNT stage of database startup？（）
    A

    renaming of data files

    B

    dropping the database user

    C

    renaming of control files

    D

    multiplexing of control files

    E

    configuring the database in ARCHIVELOG mode


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

  • 第11题：

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


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

  • 第12题：

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


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    The database is configured for automatic archive logging. Along with the other required parameters， this entry is in the initialization file：log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1？（）

    • A、control file
    • B、tnsnames.ora
    • C、data dictionary
    • D、initialization parameter file

    正确答案:B

  • 第17题：

    Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）

    • A、any control file
    • B、any archive log file
    • C、one of the redo log members
    • D、loss of the initialization parameter file
    • E、any data file belonging to the default permanent tablespac

    正确答案:A

  • 第18题：

    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

  • 第19题：

    多选题
    Which two statements are correct about database transportation? （）
    A

    The source and target platforms must be the same

    B

    Redo logs, control files and temp files are also transported

    C

    The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    D

    The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

    E

    Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format


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

  • 第20题：

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


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

  • 第21题：

    多选题
    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


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

  • 第22题：

    多选题
    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. （）(Choose two.)
    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.


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

  • 第23题：

    多选题
    Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）
    A

    Change in the Oracle Database version

    B

    Change in your network infrastructure

    C

    Change in the hardware configuration of the database server

    D

    Migration of database storage from non-ASM to ASM storage

    E

    Database and operating system upgrade


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

  • 第24题：

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

相关内容