Free 1z0-076 Questions for Oracle 1z0-076 Exam

Question #1

Which three statements are true....... With no Oracle Streams or Goldengate configured?

A. They are required on a physical standby for real-time apply.

B. They are required only for synchronous redo transport

C. The LGWR process writes to them on ....

D. It is recommended to have them on the...

E. They are required on a logical standby for real-time apply

F. Only standby databases can write redo....

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #2

Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?

A. If the primary database is a container database, then a logical standby may be a non-container database.

B. If the primary database is not a container database, then a standby may be a container database.

C. If the primary database is a container database, then a physical standby may be a non-container database.

D. All broker actions execute at the root container for container databases.

E. After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #3

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

A. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

B. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

C. Primary and physical standby databases may use different virtual recovery catalogs in the same physical recovery catalog.

D. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

E. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

Discussion 0

Correct Answer: B,C Vote an answer

Question #4

Examine the Data Guard configuration:

What happens if you issue "switchover to sheep;" at the DGMGRL prompt?

A. It results in an error indicating that a switchover is not allowed.

B. The switchover succeeds but Dogs needs to be reinstated.

C. The switchover succeeds and Dogs becomes the new failover target.

D. The switchover succeeds and Cats becomes the new failover target.

E. The switchover succeeds and Fast-Start Failover is suspended.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #5

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which set of actions will fulfill this requirement?

A. Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

B. Set the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

C. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

D. Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #6

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?

A. A physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing

B. A far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing

C. These requirements cannot be met.

D. A snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #7

You must configure an Oracle Data..........
1. A primary database
2. A physical standby database
Examine these requirements: 1. Data loss is not permitted.
1. Data loss is not permitted.
2. It should be possible to convert the physical standby database to a snapshot standby database.
3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it has been received by the standby database instance.
4. The availability of the primary database should not be compromised by the availability of the standby database.
5. It should be possible to convert the physical standby database to a logical standby database
6. It should be possible to deploy Real Application Clusters on the primary database.
7. It should be possible to deploy Real Application Clusters on the physical standby database.
You configure SYNC redo transport mode in combination with Maximum Protection mode.

A. 1, 2, 6, and 7

B. 1, 6, and 7

C. 1, 2, 3, 4, 5, 6, and 7

D. 1, 2, and 5

E. 1, 2, 3, 6, and 7

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #8

Which three are prerequisites for enabling Fast-Start Failover?

A. The maximum protection mode can be used, but with two or more standby databases.

B. Flashback Database must be enabled only on the Fast-Start Failover target standby database.

C. The configuration must be operating in either Maximum Performance or Maximum Protection mode.

D. The Data Guard environment must be managed by the Data Guard Broker.

E. You can specify only one standby database as the fast-start failover target.

F. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

Discussion 0

Correct Answer: D,E,F Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #9

Which THREE are true about using flashback database in a Data Guard environment?

A. You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption.

B. It may not be used to flash back a primary database after a failover to a physical standby.

C. It may be used to flash back a physical standby that receives redo from a far sync instance.

D. When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically.

E. You can use it when real-time apply is enabled in case the phylt may not be used to flash back a primary database after a failover to a logical standby.

F. When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically.

Discussion 0

Correct Answer: A,B,C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Free 1z0-076 Questions for Oracle Database 19c: Data Guard Administration 1z0-076 Exam as PDF & Practice Test Engine

Download Free Oracle 1z0-076 Demo