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

Vce 1z0-066 Questions Latest

Page: 4 / 4
Total 112 questions

Oracle Database 12c: Data Guard Administrator Questions and Answers

Question 13

Which four database parameters might be affected by or influence the creation of standby databases? (Choose four.)

Options:

A.

DB_NAME

B.

ARCHIVE_LAG_TARGET

C.

COMPATIBLE

D.

DB_FILE_NAME_CONVERT

E.

DB_UNIQUE_NAME

F.

FAL_SERVER

G.

STANDBY_ARCHIVE_DEST

Question 14

Which three statements are true about snapshot standby databases? (Choose three.)

Options:

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.

Question 15

A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it.

All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter.

Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state? (Choose three.)

Options:

A.

Recover the datafile by using the RMAN RECOVER DATAFILE command

B.

Restart the redo apply.

C.

Restore the datafile by using the RMAN RESTORE DATAFILE command.

D.

Stop the redo apply.

E.

Recover the database by using the RMAN RECOVER DATABASE command.

Question 16

Examine the Data Guard configuration:

DGMGRL> show configuration verbose;

Configuration - Animals

Protection Mode: MaxPerformance

Databases:

cats - Primary database

dogs - (*) Physical standby database

sheep - Physical standby database

(*) Fast-Start Failover target

Properties:

FastStartFailoverThreshold = ‘30’

OperationTimeout = ‘30’

TraceLevel = ‘USER’

FastStartFailoverLagLimit = ‘30’

CommunicationTimeout= ‘180’

ObserverReconnect= ‘10’

FastStartFailoverAutoReinstate= ‘FALSE’

FastStartFailoverPmyShutdown= ‘TRUE’

BystandersFollowRoleChange= ‘none’

ObserverOverride = ‘FALSE’

Fast-Start Failover: ENABLED

Threshold: 30 seconds

Target: dogs

Observer: ol5.example.com

Lag Limit: 30 seconds

Shutdown Primary:TRUE

Auto-reinstate: FALSE

Observer Reconnect: 10 seconds

Observer Override: TRUE

Configuration Status:

SUCCESS

Which two are true? (Choose two.)

Options:

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 after a failover.

Page: 4 / 4
Total 112 questions