1Z0-066無料問題集「Oracle Database 12c: Data Guard Administrator」

質問 1

Which two statements are true for Data Guard environments with multi-tenant databases? (Choose two.)

（A）The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.

（B）A multi-tenant standby database can have fewer pluggable databases than the primary container database.

（C）Different pluggable databases within a logical standby database may have different guard statuses.

（D）The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

（E）The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

正解：A、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

Which two are true about rolling release upgrades in a Data Guard environment? (Choose two.)

（A）The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.

（B）A physical standby database can be converted to a logical standby database temporarily.

（C）Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.

（D）The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

（E）The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure.

正解：A、B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

Which three factors can influence the rate of redo apply on a physical standby database? (Choose three.)

（A）the number of archiver processes on the standby database

（B）the network latency between the primary and standby databases

（C）the rate of redo generation on the primary database

（D）the number and size of standby redo logs on the primary database

（E）the number and size of standby redo logs on the standby database

正解：A、B、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. Three Physical Standby Databases
You must meet these requirements:
1. A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

（A）ASYNC and Maximum Performance

（B）SYNC NOAFFIRM and Maximum Availability

（C）SYNC NOAFFIRM and Maximum Protection

（D）SYNC AFFIRM and Maximum Availability

（E）SYNC AFFIRM and Maximum Protection

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control? (Choose two.)

（A）A logical standby database is the only standby database in the data guard configuration.

（B）The primary and standby databases are hosted on different operating systems.

（C）A snapshot standby database is the only standby database in the Data Guard configuration.

（D）Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.

（E）A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.

正解：A、B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
------------------ --------------------------
BYSTANDER cats
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
---------------------------- -------------------------
NO ol7.example.com
Which are true?

（A）The observer is currently running on ol7.example.com.

（B）The observer is not running, but should run on ol7.example.com.

（C）The observer is connected to the database on which the query was executed.

（D）Cats is a bystander database.

（E）The observer is not connected to the database on which the query was executed.

正解：E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements:
1. Data loss is not permitted.
2. Read-only applications should not connect to the primary database instance.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest databases?

（A）a primary database with three physical standby databases

（B）a primary database with one logical standby database

（C）a primary database with one logical and one physical standby database

（D）a primary database with two physical standby databases

（E）a primary database with one physical standby database

（F）a primary database with one logical and two physical standby databases

正解：C 解答を投票する

質問 8

Which three statements are true about Data Guard database modes and states? (Choose three.)

（A）A primary database may ship redo directly to more than mine standby databases.

（B）Force Logging Mode is not required for a primary database but is recommended.

（C）Databases in a Data Guard Configuration need not operate in Flashback Logging mode.

（D）A Logical Standby Database can be in MOUNT state while applying changes.

（E）The Primary Database can operate in noarchivelog mode.

正解：A、B、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

Which two statements are true about block media recovery in a Data Guard environment? (Choose two.)

（A）When using RMAN, the RECOVER CORRUPTION LIST command can automatically use blocks from flashback logs.

（B）DB_LOST_WRITE_PROTECT must be set to TYPICAL to enable Automatic Block Media Recovery.

（C）A corrupt block on the primary database can be recovered automatically, using blocks from a physical standby database that has the Real-Time Query enabled.

（D）DB_LOST_WRITE_PROTECT must be set to FULL to enable Automatic Block Media Recovery.

（E）When using RMAN, the RECOVER CORRUPTION LIST command can use blocks from change tracking files.

正解：C、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases.
Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary? (Choose three.)

（A）The upgrade requires downtime until the upgrade of the primary is completed.

（B）Fast-Start Failover can be used to protect the primary database during the upgrade.

（C）The broker must be disabled during the upgrade.

（D）The new release of the Oracle Software must be installed on both the primary and standby database hosts.

（E）With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.

（F）The upgrade requires downtime until the upgrade of the standby is completed.

（G）Redo Apply on the standby database must be stopped while the primary database is upgraded.

正解：A、C、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

1Z0-066 無料問題集「Oracle Database 12c: Data Guard Administrator」

弊社を連絡する

関連リンク

トップ試験