[2025] 1z0-076 Exam Dumps, Test Engine Practice Test Questions [Q28-Q42]

admin 1z0-076 Oracle December 18, 2025

5/5 - (1 vote)

[2025] 1z0-076 Exam Dumps, Test Engine Practice Test Questions

Pass 1z0-076 exam [Dec 18, 2025] Updated 111 Questions

Oracle 1z0-076 Exam Syllabus Topics:

Topic	Details
Topic 1	Managing Physical Standby Files After Structural Changes on the Primary Database: The topic covers managing structural changes in the primary database and their impact on physical standby files.
Topic 2	Enhanced Client Connectivity in a Data Guard Environment: This topic focuses on enhancing client connectivity in a Data Guard setup and implementing failover procedures for seamless client redirection. It also covers application continuity to ensure uninterrupted operations during role transitions.
Topic 3	Oracle Data Guard Broker Basics: An overview of the Data Guard broker, its architecture, components, benefits, and configurations, is provided here. It serves as an introduction to the tool used for managing Data Guard configurations.
Topic 4	Patching and Upgrading Databases in a Data Guard Configuration: This section provides guidance on patching and upgrading databases in a Data Guard environment, along with performance optimization techniques and monitoring considerations.
Topic 5	Using Oracle Active Data Guard: Supported Workloads in Read-Only Standby Databases: Here, the usage of physical standby databases for real-time queries is discussed.
Topic 6	Creating a Data Guard Broker Configuration: This section delves into the practical aspects of creating and managing a Data Guard broker configuration, including command-line and Enterprise Manager approaches.
Topic 8	Oracle Data Guard Basics: This topic covers the essential architecture and concepts of Oracle Data Guard. It includes sub-topics such as the physical and logical standby database comparison, benefits of Data Guard, and its integration with multi-tenant databases.
Topic 9	Performing Role Transitions: Here, the concept of database roles is explained, along with the steps for performing switchovers, failovers, and maintaining physical standby sessions during role transitions.
Topic 10	Using Flashback Database in a Data Guard Configuration: This topic covers the configuration and advantages of using Flashback Database in a Data Guard setup, as well as the process of enabling fast-start failover for seamless role changes.
Topic 11	Monitoring a Data Guard Broker Configuration: The topic covers the use of Enterprise Manager and DGMGRL to monitor Data Guard configurations and explains the various data protection modes available.
Topic 12	Managing Oracle Net Services in a Data Guard Environment: The section focuses on Oracle Net Services and its role in Data Guard networking setup.
Topic 13	Backup and Recovery Considerations in an Oracle Data Guard Configuration: In this topic, Backup and recovery procedures in a Data Guard configuration are discussed, including RMAN backups, offloading to physical standby, and network-based recovery.

NEW QUESTION 28
Which THREE statements are true about snapshot standby databases?

A snapshot standby database may be opened read-only.

FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled.

FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled.

A snapshot standby database can have Real-Time apply enabled.

A snapshot standby database may be opened read-write.

FLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database.

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

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

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

You can check if redo apply needs to be tuned.

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

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

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

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

If DB_RECOVERY_FILE_DEST is specified, then LOG_ARCHIVE_DEST_n is not required for local archive logs.

The databases that are part of a Data Guard configuration must have different DB_UNIQUE_NAME initialization parameters.

COMPATIBLE must have identical values for primary and standby databases.

LOG_FILE_NAME_CONVERT applies to online redo logs and archived logs.

DB_FILE_NAME_CONVERT is only required if the standby database is on the same host as the primary database.

NEW QUESTION 31
Examine this query and its output:

Which two statements are true?

The master observer is connected to the database on which the query was executed.

The master observer is currently running on ol7.example.com.

The master observer is not running, but should run on ol7.example.com.

Cats is a bystander database.

The master observer is not connected to the database on which the query was executed.

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

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

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

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

You can check if redo apply needs to be tuned.

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

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

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

It protects against user errors being replicated to standby databases.

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

It protects against logical corruptions being replicated to standby databases.

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

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

NEW QUESTION 34
You must configure flashback database for your Oracle 19c databases that will be part of a Data Guard Broker configuration.
The databases are all in ARCHIVELOG mode.
You will execute the SQL statement:
ALTER DATABASE FLASHBACK ON;
Which three are true concerning this command?

It will execute successfully while an Oracle 19c primary database is open.

It will execute successfully while an Oracle 19c primary database is mounted.

It will execute successfully on an Oracle 19c physical standby database while Real Time Query is active.

If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all logical standby databases that are part of the configuration.

It will execute successfully on an Oracle 19c logical standby database while SQL apply is active.

If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all physical standby databases that are part of the configuration.

NEW QUESTION 35
Active Data Guard (ADG) databases are widely used to offload reporting or ad hoc query-only jobs from the primary database. Reporting workload profile is different from the primary database and often requires tuning.
Which tool is used to tune SQL workloads running on an ADG database?

Standby Statspack

In-Memory Active Session History (ASH)

Automatic Diagnostic Database Monitor (ADDM)

Automatic Workload Repository (AWR)

SQL Tuning Advisor

NEW QUESTION 36
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?

It can only be enabled for a configuration in Maximum Availability mode.

It allows user errors on the primary to be recovered by using the physical standby database.

It can only be enabled for a configuration in Maximum Performance mode.

It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

It allows logical corruptions on the primary to be recovered by using the physical standby database.

It enables you to bypass the default network timeout interval specified for the standby redo transport destination.

NEW QUESTION 37
Examine the following parameter settings of the physical standby database:
* STANDBY_FILE_MANAGEMENT=AUTO
* ENABLED_PDBS_ON_STANDBY=<null>
During which TWO tasks are files automatically created in the physical standby database after structure changes on the primary database?

Performing transportable tablespaces

Adding or dropping a redo file group

Adding a data file or creating a tablespace

Creating a PDB from the existing PDB within the same CDB

Renaming a data file in the primary database

NEW QUESTION 38
Examine this query and its output:

Which two statements are true?

The master observer is connected to the database on which the query was executed.

The master observer is currently running on ol7.example.com.

The master observer is not running, but should run on ol7.example.com.

Cats is a bystander database.

The master observer is not connected to the database on which the query was executed.

NEW QUESTION 39
Which three are prerequisites for using Data Guard Broker?

The primary and standby databases must run the same version of the Oracle Database server.

Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances.

DG_BROKEB_START must be set to TRUE for a database instance before adding the database to the broker configuration.

If any database in the configuration is a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration.

The broker configuration files for a RAC database must reside in shared storage accessible by all the RAC database instances.

A statically defined listener end-point must be registered with the local listener on the servers hosting the standby database instances.

NEW QUESTION 40
Which TWO statements are true about Real-Time Query?

Setting standby_max_data_delay=0 requires synchronous redo transport.

Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.

Real-Time Query sessions can be connected to a Far Sync instance.

A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

NEW QUESTION 41
Your expertise is requested for these customer requirements:
The Data Guard environment must be in maximum protection mode.
Reports must be offloaded to a physical standby database.
There must be no lag between the primary and standby databases that affect the reports produced.
The primary database must be resilient in case of a single network failure.
Which solution is correct for these requirements?

Two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

One physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected to the primary

One physical standby database with Real-Time Query enabled and STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

Two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attributes SYNC NOAFFIRM to minimize the performance impact on the primary

NEW QUESTION 42
Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled.
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors: ORA-03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

Increase the size of the buffer cache on the standby database instance.

Reduce I/O latency for the storage used by the primary database.

Increase the number of standby redo log files on the primary database.

Change the protection mode to Maximum Performance.

Increase the network bandwidth between the primary and standby databases.

Change the protection mode to Maximum Protection.