Oracle 1Z0-066 Free Practice Questions

NEW QUESTION 1
Which three are required in order to use Real-Time Query without lagging behind the primary?

• A. There must be standby redo logs on the standby database
• B. There must be standby redo logs on the primary database.
• C. The primary must ship redo asynchronously.
• D. COMPATIBLE must be set to 11.1.0 or higher.
• E. Real-Time apply must be enabled on the standby.

Answer: ADE

NEW QUESTION 2
A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

• A. a remote physical standby database with RedoRoutesvia a far sync instance
• B. a snapshot standby database with synchronous redo transport
• C. a physical standby database with real-time query enabled
• D. a logical standby database
• E. a read mostly implementation of a physical standby database

Answer: BC

NEW QUESTION 3
Examine the Data Guard configuration: DGMGRL> show configuration Configuration-Animals
Protection Mode: MaxAvailability Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration Dogs - (*) Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED Configuration Status: WARNING And the fast-start failover configuration:
DGMGRL> show fast_start failover; Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dogs
Observer: 017.example.com Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate: TRUE Observer Reconnect 10 seconds Observer Override: FALSE
Configurable Failover Conditions Hearth Conditions: Corrupted Controlfile YES Inaccessible Logfile NO
Stuck Archiver NO Datafile Offline YES Oracle error Conditions
ORA-01578: ORACLE data block corrupted (file # %s, block # %s) And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats;
LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

• A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
• B. MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.
• C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep
• D. Open Dogs and let the broker reinstate Dogs automatically.

Answer: C

NEW QUESTION 4
A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

• A. a remote physical standby database with RedoRoutesvia a far sync instance
• B. a snapshot standby database with synchronous redo transport
• C. a physical standby database with real-time query enabled
• D. a logical standby database
• E. a read mostly implementation of a physical standby database

Answer: BC

NEW QUESTION 5
You must manually reinstate a database using DGMGRL
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?

• A. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration
• B. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration
• C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.
• D. The target database should be MOUNTED and DGMGRL should be connected to the target database
• E. The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database

Answer: C

NEW QUESTION 6
Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard?

• A. it checks that supplemental logging is turned on if there is a logical standby database in the configuration.
• B. it verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.
• C. It checks that the current data protection level is consistent with the broker's configured data protection mode.
• D. it modifies the database configurable parameters to match the values set for the broker configuration.
• E. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

Answer: ABC

NEW QUESTION 7
You have a Data Guard Broker configuration called Somewhere' as shown:

Which two are true about the output of this DGMGRL command?

• A. A far sync instance cannot have inconsistent properties because it has no database.
• B. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.
• C. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.
• D. Any inconsistency reported is on an instance-specific basis.

Answer: CD

NEW QUESTION 8
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 NOAFFIRM and Maximum Protection
• C. SYNC AFFIRM and Maximum Availability
• D. SYNC NOAFFIRM and Maximum Availability
• E. ASYNC and Maximum Performance

Answer: C

NEW QUESTION 9
A Data Guard environment has this configuration and these attributes:
1. The primary database prima is in the local region.
2. A physical standby database physt1 is in the local region.
3. A physical standby database physt2 is in a remote region.
4. The primary ships redo to physt1.
5. physt1 ships redo physt2.
6. 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. The sequence is usable on physt1 and physt2
• B. The sequence is usable on physt1 but not usable on physt2.
• C. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primarydatabase.
• D. physt2 will no longer receive redo if phystl becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
• E. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Answer: CE

NEW QUESTION 10
Which three are true concerning database states after a successful switchover?

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

Answer: ABE

NEW QUESTION 11
Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to SYNC.
4. Real-time query is enabled for both standby databases.
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.
You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

• A. Increase the size of the buffer cache on the physical standby database instances.
• B. Increase the number of standby redo log files on the standby databases.
• C. Decrease the redo log file size on the primary database.
• D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
• E. Increase the size of standby redo log files on the standby databases.

Answer: AD

NEW QUESTION 12
You must manually reinstate a database using DGMGRL
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?

• A. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration
• B. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration
• C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.
• D. The target database should be MOUNTED and DGMGRL should be connected to the target database
• E. The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database

Answer: C

NEW QUESTION 13
Which four factors can influence the rate of SQL apply on a logical standby database?

• A. the size of the undo tablespace on the logical standby database
• B. the number of full table scans performed by SQL apply
• C. the number of coordinator processes on the standby database instance
• D. the size of the shared pool
• E. the number of APPLIER processes
• F. the number of PREPARER processes

Answer: BDEF

NEW QUESTION 14
Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

• A. Sheep will be in the disabled state.
• B. Sheep will be in the enabled state.
• C. Dogs will be in the disabled state and has to be manually reinstated
• D. The configuration will be in Maximum Performance mode.
• E. The configuration will be in Maximum Availability mode.

Answer: BCD

NEW QUESTION 15
Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors: ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

• A. Change the protection mode to Maximum Performance.
• B. Increase the size of the buffer cache on the standby database instance.
• C. Reduce I/O latency for the storage used by the primary database.
• D. Change the protection mode to Maximum Protection.
• E. Increase the network bandwidth between the primary and standby databases
• F. Increase the number of standby redo log files on the primary database

Answer: AE

NEW QUESTION 16
Examine the Data Guard configuration:

Identify two possible reasons for this error.

• A. The FastStartFailoverTarget property is not set on Sheep.
• B. The FastStartFailoverTarget property is not set on Dogs.
• C. The FastStartFailoverTarget property is not set on DogsFSI.
• D. The LogXptMode property is set to ASYNC on Dogs.
• E. The RedoRoutes property is not set on Dogs
• F. The RedoRoutes property is not set on DogsFSI

Answer: AD

NEW QUESTION 17
Examine the Fast-start configuration

Oracle Error Conditions: (none) Which three are true?

• A. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
• B. An automatic failover will be initiated even if the target standby database lags behind the primary
• C. The observer is running
• D. a failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database
• E. The configuration operates in Maximum Availability mode
• F. The configuration operates in Maximum Performance mode

Answer: ACE

NEW QUESTION 18
There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database. The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12. Identify two changes, each of which would allow you to increase the number of APPLIER processes.

• A. Increase the PROCESSES initialization parameter
• B. Increase the value for the MAX_SERVERS SQL apply parameter.
• C. Decrease the number of archiver processes on the standby databas
• D. increase the PARALLEL_MAX_SERVER initialization parameter
• E. Decrease the number of PREPARER processes
• F. Increase the RECOVERY_PARALLEUSM initialization parameter

Answer: BE

NEW QUESTION 19
A Data Guard environment has this configuration and these attributes:
1. A primary database
2. A Physical Standby Database named sbdb
3. The configuration is in maximum availability protection mode.
Then sbdb is converted to a snapshot standby database When two statements are true?

• A. Sdbd can still apply redo
• B. The recovery point objective increases
• C. The protection mode is lowered to maximum performance
• D. The recovery time objective increases.
• E. Sbdb can still receive redo

Answer: DE