We offers . "Oracle Database 12c: Data Guard Administration", also known as 1Z0-066 exam, is a Oracle Certification. This set of posts, Passing the 1Z0-066 exam with , will help you answer those questions. The covers all the knowledge points of the real exam. 100% real and revised by experts!

Free 1Z0-066 Demo Online For Microsoft Certifitcation:

NEW QUESTION 1
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 2
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 3
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 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 two are true about offloading backups to a physical standby database in a Data Guard environment?

  • A. The standby database must be registered in an RMAN catalog after the primary database has been registered
  • B. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered
  • C. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file onthe primary database.
  • D. The standby database must be registered in an RMAN catalog before the primary database has been registered

Answer: BC

NEW QUESTION 6
Which three statements are true about Far Sync instances?

  • A. The Data Guard Broker must be used to deploy and manage Far Sync instances.
  • B. They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.
  • C. A primary database can ship redo directly to multiple Far Sync instances.
  • D. They use as spfile, a standby controlfile, and standby redo logs.
  • E. They work with any protection level.

Answer: ABD

NEW QUESTION 7
Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

  • A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
  • B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
  • C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE
  • D. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.
  • E. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host

Answer: AB

NEW QUESTION 8
Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

  • A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
  • B. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered
  • C. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
  • D. backups of data files taken on the logical standby database, if not connected to a recovery catalog
  • E. backups of control files taken on the logical standby database if not connected to a recovery catalog

Answer: ADE

NEW QUESTION 9
Which four database parameters might be affected by or influence the creation of standby databases?

  • A. DB_NAME
  • B. ARCHIVE_LAG_TARGET
  • C. COMPATIBLE
  • D. DB_FILE_NAME_CONVERT
  • E. DB_UNIQUE_NAME
  • F. FAL_SERVER
  • G. STANDBY_ARCH1VE_DEST

Answer: ADEF

NEW QUESTION 10
Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment?

  • A. a flash recovery area must be configured
  • B. The database must be in MOUNT state.
  • C. The database must be in ARCHIVELOG mode.
  • D. A far sync instance must be configured to flash back a standby when the primary has been flashed back.
  • E. The Data Guard Broker must be used.

Answer: AC

NEW QUESTION 11
You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?

  • A. The standby database must have supplemental logging enabled.
  • B. The primary database must have FORCE LOGGING enabled
  • C. The DG_BROKER_START parameter must be set to TRUE for both database instances.
  • D. The primary database must have supplemental logging enabled.
  • E. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.

Answer: BC

NEW QUESTION 12
Which two statements are true about Real-Time Query?

  • A. Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.
  • B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.
  • C. Real-Time Query sessions can be connected to a Far Sync instance.
  • D. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
  • E. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

Answer: BD

NEW QUESTION 13
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 beopen 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 14
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 15
Examine the Data Guard configuration;
1Z0-066 dumps exhibit
What can you conclude based on this error?

  • A. Cats is a snapshot standby database
  • B. The redo transport mode is set to ASYNC for the standby database Sheep
  • C. The redo transport mode is set to ASYNC for both standby databases
  • D. The redo transport mode is set to ASYNC for the standby database Cats

Answer: B

NEW QUESTION 16
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 17
Which three are prerequisites for enabling Fast-Start Failover?

  • A. The Fast-Start Failover target standby database must receive REDO directly from the primary database
  • B. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.
  • C. Flashback Database must be enabled only on the Fast-Start Failover target standby database.
  • D. The configuration must be operating in either Maximum Performance or Maximum Availability mode
  • E. The configuration must be operating in either Maximum Performance or Maximum Protection mode
  • F. The Data Guard environment must be managed by the Data Guard Broker.

Answer: BDF

NEW QUESTION 18
Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user?

  • A. Real Time Query must be enabled on the primary database
  • B. Real Time Query must be enabled on the physical standby database.
  • C. |f a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.
  • D. If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved
  • E. if a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.
  • F. If a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.

Answer: BCD

NEW QUESTION 19
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

  • A. To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
  • B. the LOCALJJSTERNER initialization parameter must be set to the listener used to register the primary database instance.
  • C. To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.
  • D. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
  • E. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

Answer: D

NEW QUESTION 20
Examine the Data Guard configuration:
1Z0-066 dumps exhibit
1Z0-066 dumps exhibit
Configuration Status: SUCCESS Which two are true?

  • A. The observer must run on host ol5.example com and is currently not running.
  • B. The observer will reinstate Sheep automatically after a failover, if required.
  • C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.
  • D. The observer will detect if the primary database is unable to accept new connections
  • E. The former primary database will not be reinstated automatically alter a failover.

Answer: BE

Thanks for reading the newest 1Z0-066 exam dumps! We recommend you to try the PREMIUM Certleader 1Z0-066 dumps in VCE and PDF here: https://www.certleader.com/1Z0-066-dumps.html (184 Q&As Dumps)