Oracle Database 19c: Data Guard Administration (1z0-076) Free Practice Test

Question 1

Which TWO are benefits of using Transaction Guard in a Data Guard environment?

A. It provides application continuity by rolling back uncommitted transactions interrupted by a failover or switchover.

B. It protects against user errors being replicated to standby databases.

C. It provides application continuity by replaying transactions interrupted by a failover or a switchover

D. It protects against recoverable errors during a planned or an unplanned outage of a primary database.

E. It protects against logical corruptions being replicated to standby databases.

Correct Answer: A,D

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

Question 2

Which three statements are true about snapshot standby databases?

A. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the primary database, will succeed.

B. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the physical standby database, will succeed.

C. A resize command to extend the size of a datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed.

D. A resize command to extend the size of a datafile in the snapshot standby database, which was created in the primary database, will succeed.

E. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed.

Correct Answer: C,D,E

Question 3

Which TWO statements are true about configuring Oracle Net Service in a Data Guard environment?

A. Install the oracle-database-preinstall-19c package to set the kernel parameters for Oracle Net based on the Data Guard best practice guidelines.

B. Enterprise Manager does not require static service registration to restart instances during the course of broker operations.

C. Installing the oracle-database-preinstall-19c package is NOT sufficient to set up operating system kernel parameters for Oracle Net.

D. A static service must be registered with the local listener to enable DGMGRL to restart instances during the course of broker operations.

E. It is necessary to use the failover clause for an address_list with multiple address lists in the tnsnames.ora file.

Correct Answer: C,D

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

Question 4

You created two remote physical standby databases using SQL and RMAN.
The primary database is a four-instance RAC database and each physical standby database has two instances.
Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.
Consider these operational requirements:
* The ability to manage multiple standby databases with a single tool
* The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases
* The automation of failovers to a specified target standby database
Which TWO tools can be used to fulfill these requirements7

A. GDCCTL

B. SQL*Plus

C. CRSCTL

D. DGMGRL

E. RMAN

F. SRVCTL

G. Enterprise Manager Cloud Control

Correct Answer: D,G

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

Question 5

Which THREE are always benefits of using a logical standby database?

A. It can be used as an updatable database for Real Application Testing and then converted back to a standby database without affecting the updates.

B. It can be used for database rolling release upgrades.

C. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

D. It can be used for reporting workloads requiring additional indexes or materialized views or both.

E. It can be used for testing patchsets without affecting the primary database.

F. It can be used to replicate a single pluggable database (PDB) in a multitenant container database.

Correct Answer: B,C,D

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

Question 6

Which two are true about database roles in an Oracle Data Guard configuration?

A. A Snapshot Standby Database can be a fast-start failover target.

B. A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

C. A Physical Standby Database can be converted into a Logical Standby Database.

D. A Logical Standby Database can cascade redo to a terminal destination.

E. A Logical Standby Database can be converted to a Snapshot Standby Database.

Correct Answer: B,C

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

Question 7

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 C

C. Option A

D. Option B

Correct Answer: B

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

Question 8

Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

A. You can set a critical threshold on the redo generation rate metric for a primary database.

B. You can monitor the redo apply rate on a logical standby database.

C. You can check the potential data loss in the event of a disaster.

D. You can check if redo apply needs to be tuned.

E. You can set a warning threshold on the redo generation rate metric for a physical standby database.

F. You can monitor the redo apply rate on a snapshot standby database.

Correct Answer: A,B,C

Question 9

Which four statements are true regarding SQL Apply filters for a logical standby database?

A. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).

B. They can be used to skip ALTER TABLE commands on specific tables.

C. They can be used to skip CREATE TABLE commands.

D. They can be used to stop SQL apply if it encounters an error.

E. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

F. They can be used to skip ALTE1 STEM and ALTER DATABASE commands.

G. They can only be used to skip DML statements on a table.

Correct Answer: B,C,E,F

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

Question 10

Which two are prerequisites for configuring flashback database for Oracle 19c databases, in a Data Guard environment?

A. The Data Guard real-time apply feature must be enabled.

B. The database must be in ARCHTVELOG mode.

C. A far sync instance must be configured to flash back a standby when the primary has been flashed back.

D. A fast recovery area must be configured.

E. The data guard broker must be used.

Correct Answer: B,D

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

Welcome to TestSimulate

Oracle Database 19c: Data Guard Administration (1z0-076) Free Practice Test