New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Note! Following 1z0-066 Exam is Retired now. Please select the alternative replacement for your Exam Certification. The new exam code is 1z0-076

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

Oracle Database 12c: Data Guard Administrator Questions and Answers

Question 1

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

Buy Now
Question 2

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 3

Your Data Guard environment has one physical standby database using Real-Time Query.

Two sequences have been created by these SQL statements:

create sequence a global;

create sequence b session;

Neither sequence has been used since being created.

Session 1 connects to the primary database instance and issues these two SQL statements:

SELECT a.nextval FROM DUAL;

SELECT b.nextval FROM DUAL;

Then session 2 connects to the physical standby database instance and issues the same SQL statements.

What output will be seen for session 2?

Options:

A.

B.

C.

D.