Online Access Free 1Z1-066 Exam Questions

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 one physical standby database
• B.a primary database with one logical standby database
• C.a primary database with two physical standby databases
• D.a primary database with three physical standby databases
• E.a primary database with one logical and one physical standby database
• F.a primary database with one logical and two physical standby databases

Which two statements are true regarding Data Guard Broker? (Choose two.)

• A.It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• B.It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
• C.It can be used to create and manage standby databases.
• D.It can be used to perform failovers and switchovers.
• E.It can be used to monitor redo transport and log apply services.

You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. A Physical Standby Database
3. A Snapshot 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 the primary database and on at least one standby database.
Which redo transport mode, and which protection mode should you configure to meet these requirements?

• A.SYNC AFFIRM and Maximum Availability
• B.SYNC AFFIRM and Maximum Protection
• C.SYNC NOAFFIRM and Maximum Protection
• D.ASYNC and Maximum Performance
• E.SYNC NOAFFIRM and Maximum Availability

You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAILABILITY using Enterprise Manager Cloud Control.
Which two are true about this change? (Choose two.)

• A.Real time apply will be automatically turned on.
• B.If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
• C.Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.
• D.Fast start failover can be enabled when making the chance.
• E.The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.

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

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