CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Sure Pass Exam 1z0-066 PDF

Page: 2 / 4
Total 112 questions
Get 1z0-066 Full Access Download 1z0-066 PDF

Oracle Database 12c: Data Guard Administrator Questions and Answers

Question 5

Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user? (Choose three.)

Options:

A.

Real Time Query must be enabled on the primary database.

B.

Real Time Query must be enabled on the physical standby database.

C.

If 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.

Question 6

You must configure an Oracle Data Guard environment consisting of:

1. A primary database

2. Three Physical Standby Databases

You must meet these requirements:

1. A designated physical standby database should become the primary database automatically whenever the primary database fails.

2. 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?

Options:

A.

SYNC NOAFFIRM 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

Question 7

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.)

Options:

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.

Question 8

Examine the Data Guard configuration:

DGMGRL > show configuration:

Configuration – Animals

Protection Mode: MaxAvailability

Databases:

dogs ‒ Primary database

cats ‒ Snapshot standby database

sheep ‒ Snapshot standby database

Fast-Start Failover: DISABLED

Configuration Status:

ORA-01034: ORACLE not available

ORA-16625: cannot reach database “dogs”

DGM-17017: unable to determine configuration status

Which three will be true after a successful failover to Cats? (Choose three.)

Options:

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.

Page: 2 / 4
Total 112 questions
Get 1z0-066 Full Access Download 1z0-066 PDF