Exam Code: 1Z0-066 (), Exam Name: Oracle Database 12c: Data Guard Administration, Certification Provider: Oracle Certifitcation, Free Today! Guaranteed Training- Pass 1Z0-066 Exam.

Online Oracle 1Z0-066 free dumps demo Below:

NEW QUESTION 1
You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration?

  • A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
  • B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
  • C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.
  • D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.
  • E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Answer: ADE

NEW QUESTION 2
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 3
Examine the Data Guard configuration:
1Z0-066 dumps exhibit
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 4
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 5
Examine this query and its output:
1Z0-066 dumps exhibit
Which are true?

  • A. The observer is not connected to the database on which the query was executed.
  • B. Cats is a bystander database.
  • C. The observer is connected to the database on which the query was executed.
  • D. The observer is currently running on o17.example com
  • E. The observer is not running, but should run on o17 example.com.

Answer: A

NEW QUESTION 6
Which two statements are true regarding Data Guard Broker?

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

Answer: BC

NEW QUESTION 7
You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
1Z0-066 dumps exhibit
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 8
In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control?

  • A. a snapshot standby database is the only standby database in the Data Guard configuration.
  • B. A logical standby database is the only standby database in the data guard configuration.
  • C. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode.
  • D. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration.
  • E. The primary and standby databases are hosted on different operating systems.

Answer: BE

NEW QUESTION 9
Which four requirements can be met by deploying a logical standby database?

  • A. Support for workloads requiring additional indexes.
  • B. it can be used to create additional schemas.
  • C. it can be used to create additional tables.
  • D. It must have the same physical structure as the primary database.
  • E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
  • F. Support for workloads requiring additional materialized views.
  • G. it can be used for Real Application Testing without affecting the disaster recovery capabilities.

Answer: ACEG

NEW QUESTION 10
Examine the Data Guard configuration:
DGMGRL > show configuration; Configuration-Animals
Protection Mode MaxPerformance Databases
dogs-Primary database sheep-Snapshot standby database cats-Snapshot standby database
Fast-Start Failover: DISABLED Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Availability: DGMGDRL> edit configuration set protection mode as max availability;
Error ORA-16627 operation disallowed since no standby databases would remain to support protection mode Failed.
Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability.

  • A. DGMGRL> convert database sheep to physical standby;
  • B. DGMGRL> convert database cats to physical standby;
  • C. DGMGRL> edit database dogs set property LogXptMode= fastsync;
  • D. DGMGRL> edit database sheep set property LogXptMode= fastsync;
  • E. DGMGRL> edit database cats set property LogXptMode= sync;

Answer: BE

NEW QUESTION 11
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 bedefined on the primary database host.

Answer: D

NEW QUESTION 12
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 13
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 14
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 15
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 16
Examine the Data Guard configuration: DGMGRL> show configuration Configuration -Animals
Protection Mode: MaxAvailability Databases:
dogs- Primary database
sheep- (*) Physical standby database cats- Physical standby database
Fast-Start Failover: ENABLED Configuration Status: SUCCESS
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

  • A. The switchover succeeds but Dogs need to be reinstated
  • B. The switchover succeeds but Fast-Start Failover is suspended.
  • C. The switchover succeeds and Cats become the new failover target.
  • D. The switchover succeeds and Dogs become the new failover target
  • E. it results in an error indicating that a switchover is not allowed.

Answer: D

NEW QUESTION 17
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 18
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

NEW QUESTION 19
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 20
On your logical standby database, you specified these rules:
1Z0-066 dumps exhibit
Which is true regarding the execution of the UNSKIP procedure?

  • A. it succeeds only if SQL apply is stopped before deleting the SQL Apply filter
  • B. it succeeds but the SQL Apply fitters are not deleted.
  • C. It deletes both the SQL Apply filters.
  • D. it returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added
  • E. it succeeds only if all DML statements executed on the primary have been applied on the logical standby

Answer: D

Recommend!! Get the Full 1Z0-066 dumps in VCE and PDF From Surepassexam, Welcome to Download: https://www.surepassexam.com/1Z0-066-exam-dumps.html (New 184 Q&As Version)