Your success in is our sole target and we develop all our in a way that facilitates the attainment of this target. Not only is our material the best you can find, it is also the most detailed and the most updated. for Oracle 1Z0-066 are written to the highest standards of technical accuracy.
Online 1Z0-066 free questions and answers of New Version:
NEW QUESTION 1
Which three statements are true about snapshot standby databases?
- A. Snapshot standby databases may be used for rolling release upgrades.
- B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
- C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
- D. a snapshot standby database can have Real-Time Query enabled
- E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.
Answer: CE
NEW QUESTION 2
Which three statements are true about snapshot standby databases?
- 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.
Answer: ABE
NEW QUESTION 3
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
NEW QUESTION 4
Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload 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
Which two are true regarding the DelayMins Database Property for the standby database?
- A. it can only be enabled for a configuration in Maximum Performance mode.
- B. It allows user errors on the primary to be recovered by using the physical standby database.
- C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
- D. it can only be enabled for a configuration in Maximum Availability mode.
- E. It allows logical corruptions on the primary to be recovered by using the physical standby database.
- F. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.
Answer: BF
NEW QUESTION 5
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 6
Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload 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
Which two are true regarding the DelayMins Database Property for the standby database?
- A. it can only be enabled for a configuration in Maximum Performance mode.
- B. It allows user errors on the primary to be recovered by using the physical standby database.
- C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
- D. it can only be enabled for a configuration in Maximum Availability mode.
- E. It allows logical corruptions on the primary to be recovered by using the physical standby database.
- F. It specifies a delay before the primary ships redo to the standby destination havingDelayMins set.
Answer: BF
NEW QUESTION 7
You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control
Which two are true about this change?
- A. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
- B. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
- 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. Real time apply will be automatically turned on.
Answer: BC
NEW QUESTION 8
You are licensed to use Oracle Active Data Guard
Which two statements are true after enabling block change tracking on a physical standby database?
- A. it allows fast incremental backups to be offloaded to the physical standby database
- B. It starts the CTWR process on the physical standby database instance
- C. it allows fast incremental backups to be taken on the primary database.
- D. It starts the RVWR process on the physical standby database instance.
- E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
- F. It starts the CTWR process on the primary database instance.
Answer: AB
NEW QUESTION 9
Which three are among the various tasks performed by the data Guard Monitor (DMON) process?
- A. performing role transitions when switchover requests are made
- B. communicating with DMON processes in other database instances that are part of the broker configuration
- C. activating role-based services appropriately in the various database instances of the configuration, based on the database role
- D. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required.
- E. maintaining information about all members of the broker configuration in binary configuration files
Answer: ABE
NEW QUESTION 10
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?
- A. if the CACHE option is set then the size of the cache must be at least 100
- B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
- C. Their usage will always have a performance impact on the primary database.
- D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
- E. They must have the NOORDER and CACHE options set.
Answer: BDE
NEW QUESTION 11
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
What is true concerning this configuration?
- A. The Close_by primary database instance forwards redo to the FSjnst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
- B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
- C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FSjnst Far Sync instance.
- D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Stan: Failover is disabled
- E. The FSjnst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.
Answer: A
NEW QUESTION 12
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 13
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 14
Attempting to start the observer raises an error DGMGRL> start observer:
DGM-16954 Unable to open and lock the Observer configuration file Failed.
Identify two possible ways to start the observer successfully
- A. Set the Observer Override property to TRUE before starting the observer
- B. Create a broker configuration and enable Fast-Start Failover before starting the observer
- C. Start the observer using a different observer configuration file.
- D. start the observer in a different working directory.
- E. Enable Fast-Start Failover before starting the observer
Answer: CD
NEW QUESTION 15
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 16
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 17
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
NEW QUESTION 18
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 19
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 20
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 three physical standby databases
- B. a primary database with one logical and two physical standby databases
- C. a primary database with one logical standby database
- D. a primary database with one logical and one physical standby database
- E. a primary database with two physical standby databases
- F. a primary database with one physical standby database
Answer: D
Thanks for reading the newest 1Z0-066 exam dumps! We recommend you to try the PREMIUM Surepassexam 1Z0-066 dumps in VCE and PDF here: https://www.surepassexam.com/1Z0-066-exam-dumps.html (184 Q&As Dumps)
