网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “多选题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 process responsible for sending redo information to the standby.CAFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.DPROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.” 相关考题
考题
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
考题
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
考题
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
考题
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.
考题
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 databaseB、To restrict the amount of space that is used by the backupsC、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.
考题
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.
考题
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 logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace
考题
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
考题
Which two file types must be included in a closed database backup taken with operating system commands？（）A、data filesB、control fileC、password fileD、online redo log filesE、initialization parameter file
考题
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.
考题
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 databaseB、To restrict the amount of space that is used by the backupsC、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.
考题
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 fileB、tnsnames.oraC、data dictionaryD、initialization parameter file
考题
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 filesB、only the current SPFILE and data files if autobackup is disabledC、only the data files and the archived redo logsD、the control file, current SPFILE file, data files, and archived redo logs
考题
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 fileB、any archive log fileC、one of the redo log membersD、loss of the initialization parameter fileE、any data file belonging to the default permanent tablespac
考题
Which two database operations can be performed at the MOUNT stage of database startup？（）A、renaming of data filesB、dropping the database userC、renaming of control filesD、multiplexing of control filesE、configuring the database in ARCHIVELOG mode
考题
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
考题
多选题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.（）ATo store the backup information of multiple databaseBTo restrict the amount of space that is used by the backupsCTo maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.DTo list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
考题
多选题Which two statements are correct about database transportation? （）AThe source and target platforms must be the sameBRedo logs, control files and temp files are also transportedCThe transported database must have the same database identifier (DBID) as the source database and cannot be changedDThe COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedERecovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
考题
多选题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？ （）Alocal database installed on the MDM onlyBlive local database installed on the BMDM onlyCsingle database on a clustered machine remote from the MDM and BMDMDlive database installed on a single Fault Tolerant Agent within IBM Tivoli Workload Scheduler networkElive database on MDM and High Availability Disaster Recovery/Data Guard standby database on BMDM
考题
单选题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.
考题
单选题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 fileB
any archive log fileC
one of the redo log membersD
loss of the initialization parameter fileE
any data file belonging to the default permanent tablespac
考题
多选题What are three purposes of the RMAN “FROM” clause?（）Ato support PUSH-based active database duplicationBto support synchronization of a standby database with the primary database in a Data environmentCTo support PULL-based active database duplicationDTo support file restores over the network in a Data Guard environmentETo support file recovery over the network in a Data Guard environment
考题
多选题Which two database operations can be performed at the MOUNT stage of database startup？（）Arenaming of data filesBdropping the database userCrenaming of control filesDmultiplexing of control filesEconfiguring the database in ARCHIVELOG mode
考题
多选题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.)ATo store the backup information of multiple databaseBTo restrict the amount of space that is used by the backupsCTo maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.DTo list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
考题
单选题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.
考题
多选题Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）AChange in the Oracle Database versionBChange in your network infrastructureCChange in the hardware configuration of the database serverDMigration of database storage from non-ASM to ASM storageEDatabase and operating system upgrade
考题
单选题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
考题
多选题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 process responsible for sending redo information to the standby.CAFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.DPROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
热门标签
最新试卷
