Limited-Time Offer: Enjoy 50% Savings! Ends in 00h 00m 00s Coupon code: 50OFF
Skip to content
Login Sign up

Free Oracle Database 19c: Data Guard Administration 1Z0-076 Exam Questions

Page: 1 / 11 Total 107 questions

Want more questions? Get Premium Access.

Question 1

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

Correct Answer: B. Read-mostly reporting applications that use global temporary tables for storing temporary data can be offloaded.; C. You might have to use sequences with global temporary tables to support read-mostly applications by using Active Data Guard.; E. The DML operations on a standby can be transparently redirected to and run on the primary database
Explanation:

In an Oracle Active Data Guard environment:

B: Read-mostly reporting applications that utilize global temporary tables to store session-specific data can be effectively offloaded to an Active Data Guard standby database, reducing the load on the primary database.

C: Sequences can be used with global temporary tables on an Active Data Guard standby database to support certain types of read-mostly applications, though some restrictions on sequence use may apply.

E: In Oracle Database 19c and later, DML redirection allows DML operations performed on an Active Data Guard standby database to be transparently redirected to the primary database. This is part of the DML Redirection feature.

Option A is incorrect because not all PL/SQL blocks run on an Active Data Guard standby database can be redirected to the primary database. Some PL/SQL executions, specifically those that would attempt to make changes to the database, are not supported on the standby.

Option D is incorrect because DDL operations on private temporary tables are not redirected; instead, private temporary tables are session-specific and are not persisted on disk, so they do not generate redo and are not applicable to an Active Data Guard standby.


Question 2

Your Data Guard environment consists of these components and settings:

A primary database supporting an OLTP workload

A remote physical standby database

Real-time query is enabled

The redo transport mode is set to SYNC

The protection mode is set to Maximum Availability

Which two statements are true regarding the DelayMins database property for the standby database?

Correct Answer: B. It allows user errors on the primary to be recovered by using the physical standby database.; E. It allows logical corruptions on the primary to be recovered by using the physical standby database.

Question 3

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

Correct Answer: A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners.; D. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.

Question 4

Attempting to start the observer raises an error:

DGMGRL> start observer;

DGM-16954: Unable to open and lock the Observer configuration file

Failed.

Identify two possible ways to start the observer successfully.

Correct Answer: B. Start the observer in a different working directory.; D. Start the observer using a different observer configuration file.

Question 5

Which three statements are true about Data Guard database modes and states?

Correct Answer: A. Force Logging Mode is not required for a primary database but is recommended.; C. A Logical Standby Database can be in MOUNT state while applying changes.; D. Databases in a Data Guard Configuration need not operate in Flashback Logging mode.

Question 6

Suppose that you manage the following databases in your environment:

* boston: Primary database with a single PDB called DEVI

* london: Physical standby database protecting the PDB called DEVI

* orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source

You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:

Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?

Correct Answer: A. Open PDBI (remote clone source) in Read Only.; C. Set STANDBY_PDB_SOURCE_FILE_DIRECTORY to <location of the PDB> in the london database.; F. Set STANDBY_FILE_MANAGEMENT to auto in the london database.
Explanation:

To automate the instantiation of a PDB in the standby database after creating a remote clone in the primary database, certain conditions must be met:

Open PDBI (remote clone source) in Read Only (A): The source PDB from which the clone is created must be open in read-only mode to ensure a consistent state during cloning.

Set STANDBY_PDB_SOURCE_FILE_DIRECTORY to <location of the PDB> in the london database (C): This parameter specifies the location on the standby database where the files from the source PDB should be placed.

Set STANDBY_FILE_MANAGEMENT to auto in the london database (F): This parameter automates the management of file changes on the standby database when structural changes occur on the primary database, ensuring that the clone operation is reflected automatically on the standby. Reference:

Oracle Multitenant Administrator's Guide

Oracle Data Guard Broker documentation


Question 7

Which four requirements can be met by deploying a logical standby database?

Correct Answer: A. Support for workloads requiring additional materialized views.; C. It can be used to create additional tables.; E. It can be used for Real Application Testing without affecting the disaster recovery capabilities.; F. Support for workloads requiring additional indexes.
Explanation:

A logical standby database is part of Oracle Data Guard and allows the standby database to be open for read-write operations, providing additional flexibility. The requirements met by a logical standby database include:

Support for workloads requiring additional materialized views (A): Logical standby databases can support materialized views, allowing for complex data summarization and reporting workloads.

It can be used to create additional tables (C): Unlike physical standby databases, logical standby databases allow for the creation of additional tables that do not exist in the primary database, enabling custom workloads and reporting.

It can be used for Real Application Testing without affecting the disaster recovery capabilities (E): Logical standby databases can be used to test application changes, patches, and upgrades while still maintaining their role as part of the disaster recovery strategy.

Support for workloads requiring additional indexes (F): Logical standby databases allow for the creation of additional indexes to optimize query performance for reporting and analytical workloads. Reference:

Oracle Data Guard Concepts and Administration

Oracle Database High Availability Overview


Question 8

Which TWO statements are true about database parameters for databases in a Data Guard environment?

Correct Answer: B. The databases that are part of a Data Guard configuration must have different DB_UNIQUE_NAME initialization parameters.; C. COMPATIBLE must have identical values for primary and standby databases.

Question 9

Which three can be done using Data Guard Broker?

Correct Answer: A. Create a new physical standby database.; D. Converting physical standby databases to snapshot standby databases.; F. Automating failover to a specified target standby database.

Question 10

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.

Correct Answer: B. 1, 2, 3, 4, 5, 6, and 7
Explanation:

When SYNC redo transport mode is combined with Maximum Protection mode, it ensures that no data loss will occur (requirement 1). The physical standby can be converted to a snapshot standby (requirement 2) and later to a logical standby database (requirement 5), satisfying both transformation requirements. Transactions commit as soon as redo data is received by the standby database (requirement 3). The availability of the primary is not dependent on the standby database in Maximum Protection mode, as the primary database will halt if the standby cannot acknowledge the redo (requirement 4), thus indirectly ensuring its availability. It is also possible to deploy Real Application Clusters on both the primary (requirement 6) and the physical standby database (requirement 7), providing high availability and scalability.

Reference Oracle Data Guard documentation detailing the requirements for different database roles, protection modes, and redo transport modes, as well as the capabilities and limitations of each configuration.


Page: 1 / 11 Total 107 questions