Oracle Database 19c: Data Guard Administration

Question 1

Examine the procedure that you plan to execute on your logical standby:
SQL> EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'DML', schema_name => 'HR', object_name => 'EMPLOYEE'); What is a prerequisite for execution of this procedure?

A. Execute the DBMS_LOGSTDBY.APPLY_SET procedure to record errors that might cause SQL Apply to stop.

B. Stop SQL Apply on the logical standby database.

C. Stop redo transport to the logical standby database.

D. Change the redo transport mode if necessary to ASYNC.

Correct Answer: B

Question 2

Which THREE statements are TRUE about the supported workload in Active Data Guard standby databases?

A. Read-mostly reporting applications that use global temporary tables for storing temporary data can be offloaded.

B. The DDL operations on private temporary tables are transparently redirected to the primary database.

C. The DML operations on a standby can be transparently redirected to and run on the primary database

D. PL/SQL blocks that you run on Active Data Guard standby databases can be always redirected to and run on the primary database.

E. You might have to use sequences with global temporary tables to support read-mostly applications by using Active Data Guard.

Correct Answer: A,C,E

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

Question 3

Examine this list of possible steps:
1. Raise the compatibility level on both databases.
2. Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

A. 5,2,4,3,6,1

B. 5,2,4,6,3,1

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

D. 5,2,4,1

E. 4,6,5,2,3,1

Correct Answer: C

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

Question 4

Which THREE statements are true about Far Sync instances?

A. They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.

B. They use an spfMe, a standby controlfile, and standby redo logs.

C. They work with any protection level.

D. A primary database can ship redo directly to multiple Far Sync instances.

E. The Data Guard Broker must be used to deploy and manage Far Sync instances.

Correct Answer: A,D,E

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

Question 5

Which THREE statements are true........ open in real time query mode, which becomes a new.

A. Sessions that have long running queries can be retained.

B. All sessions are disconnected and all

C. All current buffers can be retained.

D. User sessions and Current Buffers are maintained by default.

E. Sessions that are using database links

F. User sessions can be retained.

Correct Answer: B,C,F

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

Question 6

A customer asks you to propose the most appropriate solution for this set of requirements:
We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
We want to generate reports from the proposed standby database at the same time that it is used for data protection.
Developers may need to test occasionally on a copy of the live database Which TWO solutions would you recommend?

A. A physical standby database with real-time apply enabled

B. A snapshot standby database with synchronous redo transport

C. A logical standby database with real-time apply enabled

D. A physical standby database with real-time query enabled

E. A logical standby database with real-time query enabled

Correct Answer: D,E

Question 7

Which TWO are TRUE about offloading backups to a physical standby database in a Data Guard environment?

A. The standby database must be registered in an RMAN catalog before the primary database has been registered.

B. The standby database can not be registered in an RMAN catalog if the primary database has not been registered.

C. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.

D. The standby database must be registered in an RMAN catalog after the primary database has been registered.

Correct Answer: C,D

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

Question 8

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?
A)

B)

C)

A. Option D

B. Option B

C. Option A

D. Option C

Correct Answer: D

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

Question 9

Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

A. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host.

B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.

C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE.

D. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.

E. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners.

Correct Answer: B,E

Oracle Database 19c: Data Guard Administration - 1z0-076 Exam Practice Test

Latest Update

Useful Links

Contact Us