1z1-076 Exam Question 41
Examine the Data Guard configuration:
What happens if you issue "switchover to sheep;" at the DGMGRL prompt?
What happens if you issue "switchover to sheep;" at the DGMGRL prompt?
1z1-076 Exam Question 42
Your Data Guard environment has one physical standby database using Real-Time Query. Two sequences have been created by these SQL statements:
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?
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?
1z1-076 Exam Question 43
A Data Guard environment has this configuration and these attributes:
The primary database prima is in the local region.
A physical standby database physt1 is in the local region.
A physical standby database physt2 is in a remote region.
The primary ships redo to physt1.
physt1 ships redo to physt2.
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?
The primary database prima is in the local region.
A physical standby database physt1 is in the local region.
A physical standby database physt2 is in a remote region.
The primary ships redo to physt1.
physt1 ships redo to physt2.
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?
1z1-076 Exam Question 44
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?
1z1-076 Exam Question 45
A customer asks for your recommendation regarding this requirement:
1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.
2. We want zero data loss in case of a disaster involving the loss of one component.
3. We want to do Real Application Testing occasionally on the Standby Database.
Which solution, if any, satisfies these requirements?
1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.
2. We want zero data loss in case of a disaster involving the loss of one component.
3. We want to do Real Application Testing occasionally on the Standby Database.
Which solution, if any, satisfies these requirements?