Online Access Free 1Z1-066 Exam Questions

Which two are prerequisites for creating a standby database using Enterprise Manager cloud control? (Choose two.)

• A.A backup of the primary database must exist.
• B.The primary database instance must be started using an SPFILE.
• C.The primary database must be in archivelog mode.
• D.The primary database must have flashback enabled.
• E.The primary host and the proposed standby database host must run the same operating system.
• F.The primary database must have FORCE LOGGING enabled.

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances? (Choose three.)

• A.The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.
• B.The client applications must use the correct TNS entries when requesting connections to the database instances.
• C.Oracle Net connectivity to the primary database instance must be established on all the standby database instances.
• D.A service name is registered with the local listener of each database instance.
• E.The standby database services must be defined statically with the Listeners running on the standby database hosts.
• F.The LOCAL_LISTENER parameter on the primary database instance must always be set.
• G.Client TNS entries for the databases use the correct service names for the intended service.

Which three are true concerning database states after a successful switchover? (Choose three.)

• A.If the former primary database became a logical standby database it will be open read-write.
• B.If the former primary database became a logical standby database it will be in mount state.
• C.If the former primary database became a physical standby database it will always be open read-only.
• D.If the former primary database became a physical standby database it will be in the same state as the former physical standby database.
• E.The new primary database will be open read-write.
• F.The former primary database will always be open.

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.The Primary Database can operate in noarchivelog mode.
• E.A Logical Standby Database can be in MOUNT state while applying changes.

Which two are true about the usage of DBMS_ROLLING? (Choose two.)

• A.The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.
• B.The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
• C.The trailing group contains the original primary database.
• D.At least one logical standby database must be part of the initial Data Guard configuration.
• E.The leading group contains the original primary database.