Oracle 1Z0-066 問題集

質問 1：
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. The upgrade requires downtime until the upgrade of the standby is completed.
C. With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.
D. The new release of the Oracle Software must be installed on both the primary and standby database hosts.
E. The broker must be disabled during the upgrade.
F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
G. Fast-Start Failover can be used to protect the primary database during the upgrade.
正解：A,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration? (Choose three.)
A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
B. Archive logs on the primary database may be deleted once they are archived locally to disk.
C. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.
E. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.
正解：A,B,D

質問 3：
Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.)
A. It permits a physical standby database to be converted to a snapshot standby database.
B. It enables the use of far sync instances.
C. It is a prerequisite for the use of Fast Start Failover.
D. It permits a primary database that was disabled after failover to be reinstated as a standby.
E. It is required in order for a snapshot standby database to be converted to a physical database.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A customer has these requirements for their proposed Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:

Which Data Guard broker commands are needed to implement these requirements?
A. EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:physt1 FASTSYNC)';EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:fs1 FASTSYNC)';EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=' (prima:physt2 ASYNC)';EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
B. EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:fs1 SYNC)';EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=' (prima:physt ASYNC)';EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
C. EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:physt1 FASTSYNC)';EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:fs1 SYNC)';EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=' (prima:physt2 SYNC)';EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
D. EDIT DATABASE prima SET PROPERTY REDOROUTES=' (LOCAL:fs1 ASYNC)';EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=' (prima:physt FASTSYNC)';EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three statements are true about snapshot standby databases? (Choose three.)
A. Tablespaces can be dropped.
B. Tables can be dropped.
C. The broker may be used to fail over to a snapshot standby database.
D. A logical standby database can be converted into a snapshot standby database.
E. Tablespaces can be created.
正解：A,B,E

質問 6：
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. One Physical Standby Database
3. One Logical Standby Database
You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database.
Which redo transport mode and which protection mode would you configure to meet these requirements?
A. SYNC AFFIRM and Maximum Protection
B. SYNC AFFIRM and Maximum Availability
C. ASYNC and Maximum Performance
D. SYNC NOAFFIRM and Maximum Protection
E. SYNC NOAFFIRM and Maximum Availability
正解：B
解説: (Topexam メンバーにのみ表示されます)