Exact 1Z0-066 Free Practice Questions 2019

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-066 Exam Dumps (PDF & VCE):
Available on: https://www.certleader.com/1Z0-066-dumps.html


Want to know features? Want to lear more about experience? Study . Gat a success with an absolute guarantee to pass Oracle 1Z0-066 (Oracle Database 12c: Data Guard Administration) test on your first attempt.

Free demo questions for Oracle 1Z0-066 Exam Dumps Below:

NEW QUESTION 1
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

NEW QUESTION 2
You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

  • A. Connect to the primary database as the AUXILIARY.
  • B. Catalog the data file copy for RMAN to use on the primary database for restore.
  • C. Back up the data file as copy on the standby host to a location on the standby host.
  • D. Switch to the data file copy using the RMAN SWITCH command.
  • E. Back up the data file as copy on the standby host to a location on the primary host
  • F. Connect to the primary database as the TARGET.

Answer: ABD

NEW QUESTION 3
Which two are true about management of a far sync instance when using the Data Guard Broker?

  • A. A far sync instance is in a disabled state in the broker configuration immediately after adding it
  • B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.
  • C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.
  • D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

Answer: AB

NEW QUESTION 4
Which four statements are true regarding SQL Apply filters for a logical standby database?

  • A. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.
  • B. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands
  • C. They can be used to stop SQL apply if it encounters an error.
  • D. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).
  • E. They can only be used to skip DML statements on a table
  • F. They can be used to skip ALTER TABLE commands on a specific tables
  • G. They can be used to skip CREATE TABLE commands

Answer: ACFG

NEW QUESTION 5
Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

  • A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
  • B. Put the primary database into archivelog mode
  • C. Startup nomount the standby database instance.
  • D. Configure Oracle Net connectivity on the primary host to the standby database instance.
  • E. Establish user equivalence for the database software owner between the primary host and standby host.

Answer: CDE

NEW QUESTION 6
Which two are true about the usage of DBMS_ROLLING?

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

Answer: DE

NEW QUESTION 7
Which three are benefits of using the Data Guard Broker to manage standby databases?

  • A. it simplifies physical standby database creation
  • B. It provides an easy failover capability using a single command.
  • C. it coordinates database state transitions and updates database properties dynamically.
  • D. it automatically changes database properties after the protection mode for a configuration is changed
  • E. It provides an easy switchover capability using a single command.
  • F. It simplifies logical standby database creation.

Answer: BCE

NEW QUESTION 8
Which four statements are true regarding SQL Apply filters for a logical standby database?

  • A. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.
  • B. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands
  • C. They can be used to stop SQL apply if it encounters an error.
  • D. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).
  • E. They can only be used to skip DML statements on a table
  • F. They can be used to skip ALTER TABLE commands on a specific tables
  • G. They can be used to skip CREATE TABLE commands

Answer: ACFG

NEW QUESTION 9
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2 Three Physical Standby Databases
You must meet these requirements:
✑ A designated physical standby database should become the primary database automatically whenever the primary database falls
✑ The chosen protection mode should provide the highest level of protection
possible without violating the other requirement
Which redo transport mode and protection mode would you configure to meet these requirements?

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

Answer: D

NEW QUESTION 10
Examine the Data Guard configuration:
1Z0-066 dumps exhibit
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 11
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 12
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 reasons for this error

  • A. Fast-Start Failover is not yet enabled for this Data Guard configuration
  • B. The observer configuration file is marked read-only.
  • C. There is already an observer running for this Data Guard configuration.
  • D. There is another observer running for a Data Guard configuration which uses the same observer configuration file
  • E. The broker configuration has not yet been created.

Answer: BD

NEW QUESTION 13
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 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 14
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 15
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

  • A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
  • B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
  • C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
  • D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.
  • E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

Answer: DE

NEW QUESTION 16
Which two are true about rolling release upgrades in a Data Guard environment?

  • A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure
  • B. A physical standby database can be converted to a logical standby database temporarily.
  • C. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.
  • D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.
  • E. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

Answer: BD

NEW QUESTION 17
Your Data Guard environment has two remote physical standby databases
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover
Which will fulfill this requirement?

  • A. Create a database service on each standby database that is started automatically by a trigger, when the database rote is PRIMARY, modify the connection description used by client applications to include all the standby hosts and connect to the database instance using that service name.
  • B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY, modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
  • C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
  • D. Set the DB_NAME and DB_UNIQUE_NAME identical on all databases, modify the connection descriptors on client applications to include all the standby hosts and connect to the database using that service name.

Answer: A

100% Valid and Newest Version 1Z0-066 Questions & Answers shared by Certleader, Get Full Dumps HERE: https://www.certleader.com/1Z0-066-dumps.html (New 184 Q&As)