Oracle 1z0-066 ExamOracle Database 12c: Data Guard Administration

Total Question: 184 Last Updated: Jun 13,2019
  • Updated 1z0-066 Dumps
  • Based on Real 1z0-066 Exams Scenarios
  • Free 1z0-066 pdf Demo Available
  • Check out our 1z0-066 Dumps in a new PDF format
  • Instant 1z0-066 download
  • Guarantee 1z0-066 success in first attempt
Package Select:

Questions & Answers PDF

Practice Test Software

Practice Test + PDF 30% Discount

Price: $65.95 $29.99

Buy Now Free Trial

Accurate 1Z0-066 Exam Questions 2019

Proper study guides for 1Z0-066 Oracle Database 12c: Data Guard Administration certified begins with preparation products which designed to deliver the by making you pass the 1Z0-066 test at your first time. Try the free right now.

Oracle 1Z0-066 Free Dumps Questions Online, Read and Test Now.

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

NEW QUESTION 4
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 5
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 6
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 7
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 8
Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?

  • A. FLASHBACK DATABASE must be enabled on the physical standby database.
  • B. There must be connectivity between the primary and the physical standby database.
  • C. FLASHBACK DATABASE must be enabled on the primary database.
  • D. The physical standby database must have Real-Time Apply enabled.
  • E. The logical standby database must have Real-Time Query enabled

Answer: CD

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 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 11
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 12
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 13
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 14
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 15
You must propose an Oracle Data Guard configuration tor a database supporting an OLTP workload 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:
3. It should be possible to apply and test designated patches with a minimum amount of downtime.
4. Upgrading to a new database release should be performed with the least possible amount of downtime.
5. New application software releases should be tested against an exact up-to-date replica
of the production database.
You propose a primary database with one physical standby database configured in Maximum Protection mode.
Which requirements do you meet?

  • A. 2,3, 4, and 5
  • B. 1,2, 3,4, and 5
  • C. 1 and 2
  • D. only requirement 5
  • E. only requirement 1

Answer: C

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

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


Related 1z0-066 Articles