Oracle 1z0-076 問題集

質問 1：
Which three statements are true about Data Guard database modes and states?
A. Force Logging Mode is not required for a primary database but is recommended.
B. A primary database may ship redo directly to more than nine standby databases.
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,C,D

質問 2：
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?
A. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.
B. The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.
C. To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
D. A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
E. To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
正解：A

質問 3：
Which three are true concerning database states after a successful switchover?
A. If the former primary database became a physical standby database it will be in the same state as the former physical standby database.
B. If the former primary database became a logical standby database it will be in mount state.
C. The former primary database will always be open.
D. If the former primary database became a physical standby database it will always be open readonly.
E. The new primary database will be open read-write.
F. If the former primary database became a logical standby database it will be open read-write.
正解：A,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two statements are true regarding asynchronous redo transport in a Data Guard
A. This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.
B. The performance of SQL apply on a logical standby database always improves when using this transport mode.
C. Real-time query performance on a physical standby database improves for current read requests when using this transport mode.
D. A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.
E. This transport mode satisfies the minimum requirements for Maximum Availability data protection mode.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three types of backups offload ........ with the primary database in a data Guard
A. Data files
B. Archive logs
C. Broker configuration files
D. Online logs
E. Control files
F. Password files
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A Data Guard environment has this configuration and these attributes:
The primary database prima is in the local region.
A physical standby database physt1 is in the local region.
A physical standby database physt2 is in a remote region.
The primary ships redo to physt1.
physt1 ships redo to physt2.
physt1 and physt2 have Real-Time Query enabled.
A sequence has been created with this SQL statement in the primary database:
CREATE SEQUENCE a NOCACHE SESSION;
Which TWO statements are TRUE?
A. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
B. The sequence is usable on physt1 and physt2.
C. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.
D. The sequence is usable on physt1 but not usable on physt2.
E. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternate redo destination has been configured on the primary database.
正解：A,B

質問 7：
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?
A. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.
B. Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host.
C. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both the Primary and the Standby.
D. Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection descriptor on the clients to use that service.
正解：D