Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. Oracle
  3. Oracle Database 12c
  4. 1z0-066 - Oracle Database 12c: Data Guard Administrator
Note! Following 1z0-066 Exam is Retired now. Please select the alternative replacement for your Exam Certification. The new exam code is 1z0-076

1z0-066 Exam Dumps - Oracle Database 12c: Data Guard Administrator

Go to page:
Question # 9

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? (Choose two.)

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.

Full Access
Question # 10

Examine the Fast-start configuration:

DGMGRL> show fast_start failover;

Fast-Start Failover: ENABLED

Threshold : 30 seconds

Target: sheep

Observer : ol7.example.com

Lag Limit: 30 seconds (not in use)

Shutdown Primary: TRUE

Auto-reinstate: TRUE

Observer Reconnect: (none)

Observer Override: FALSE

Configurable Failover Conditions

Health Conditions:

Corrupted Controlfile YES

Corrupted Dictionary YES

Inaccessible Logfile NO

Stuck Archiver YES

Datafile Offline YES

Oracle Error Conditions:

(none)

Which three are true? (Choose three.)

A.

The observer will initiate a failover when the primary database is unable to produce local archived redo log files.

B.

An automatic failover will be initiated even if the target standby database lags behind the primary.

C.

The observer is running.

D.

A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database.

E.

The configuration operates in Maximum Availability mode.

F.

The configuration operates in Maximum Performance mode.

Full Access
Question # 11

Examine this command executed on a physical standby database to transition it to a logical standby database:

SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;

Which statement is true regarding the execution of this command?

A.

FLASHBACK is automatically enabled when transitioning to the logical standby database.

B.

The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.

C.

Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.

D.

SQL apply is automatically started when transitioning to the logical standby database.

E.

It will automatically start redo apply.

Full Access
Question # 12

Which two statements are true about Far Sync instances? (Choose two.)

A.

They work in Maximum Availability mode.

B.

They work in Maximum Performance mode.

C.

They work in Maximum Protection mode.

D.

They do not work with Logical Standby databases.

E.

They do not work with Snapshot Standby databases.

Full Access
Question # 13

Which three are true concerning archive logs in a Data Guard Environment? (Choose three.)

A.

A physical standby database instance chooses an appropriate location for writing its own standby archive logs automatically.

B.

A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote logical standby database instance to which it routes redo, is not reachable.

C.

A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote physical standby database instance to which it routes redo, is not reachable.

D.

A logical standby database instance writes online redo logs.

E.

A logical standby database chooses an appropriate location for writing its own standby archive logs automatically.

F.

A physical standby database instance writes online redo logs.

Full Access
Question # 14

Which two statements are true about block media recovery in a Data Guard environment? (Choose two.)

A.

When using RMAN, the RECOVER CORRUPTION LIST command can automatically use blocks from flashback logs.

B.

A corrupt block on the primary database can be recovered automatically, using blocks from a physical standby database that has the Real-Time Query enabled.

C.

DB_LOST_WRITE_PROTECT must be set to TYPICAL to enable Automatic Block Media Recovery.

D.

When using RMAN, the RECOVER CORRUPTION LIST command can use blocks from change tracking files.

E.

DB_LOST_WRITE_PROTECT must be set to FULL to enable Automatic Block Media Recovery.

Full Access
Question # 15

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? (Choose two.)

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 primary database.

D.

physt2 will no longer receive redo if physt1 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.

Full Access
Question # 16

Which three are prerequisites for enabling Fast-Start Failover? (Choose three.)

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.

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps