New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Pass the Oracle Oracle Database 19c 1z0-076 Questions and answers with CertsForce

Viewing page 4 out of 4 pages
Viewing questions 31-40 out of questions
Questions # 31:

Which three are true about using Flashback database through role transitions in a Data Guard environment?

Options:

A.

Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.


B.

Logical standby databases retain their current role when you flash back through to a point in time before the switchover occurred which caused this database to become a logical standby.


C.

Logical standby database roles are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.


D.

Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.


E.

Flashback database may not be used to undo a physical standby database activation.


Expert Solution
Questions # 32:

Your Data Guard environment has one physical standby database using Real-Time Query. Two sequences have been created by these SQL statements:

Question # 32

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. Which output will be seen for session 2?

Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?

A)

Question # 32

B)

Question # 32

C)

Question # 32

D)

Question # 32

Options:

A.

Option A


B.

Option B


C.

Option C


D.

Option D


Expert Solution
Viewing page 4 out of 4 pages
Viewing questions 31-40 out of questions