Oracle 1z1-076 Certification All-in-One Exam Guide Jan-2026 [Q47-Q65]

January 9, 2026 admin 0 Comments

4.4/5 - (8 votes)

Oracle 1z1-076 Certification All-in-One Exam Guide Jan-2026

Get Real 1z1-076 Exam Dumps [Jan-2026] Practice Tests

NEW QUESTION 47
Examine the fast-start failover configuration:

A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database

If South_Sales develops a problem and cannot be the target of a failover, the broker automatically changes the fast-start failover target to one of the other candidate targets.

The observer will initiate a failover when the primary database is unable to produce local archived redo log files.

You must disable fast-start failover first to change the fast-start failover target to East sales.

The observer is running.

NEW QUESTION 48
Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?

converting the designated physical standby database into a logical standby database

creating a guaranteed restore point on the standby databases

building a LogMiner dictionary on the primary database instance

creating a guaranteed restore point on the primary database

starting media recovery on all the Leading Group Standby databases

switching the primary database to the logical standby role

NEW QUESTION 49
You notice that the SQL apply lag on your logical standby database has increased but the redo transport lag has not.
Which four could be reasons for the increase in SQL apply lag?

An undersized undo tablespace on the logical standby

Many SQL apply operations do full table scans

An increased number of bulk updates on the primary

An increased number of bulk inserts on the primary

The standby redo log files are undersized on the primary database

An undersized shared pool

NEW QUESTION 50
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 51
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration – Animals
Protection Mode: Max Availability
Databases:
dogs – Primary database sheep
– Physical standby database cats
– Physical standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
An attempt to enable fast-start failover raises an error:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover Failed.
Identify three possible reasons for this error.

The fastStartFailoverTarget property is not set on Dogs.

The LogxptModr property is set to async on Sheep while Sheep is the target standby database.

The LogXptMode property is set to FASTSYNC on Cats while Sheep is the target standby database.

The LogXptMode property is set to async on Dogs.

The LogXptMode property is set to fastsync on Dogs.

NEW QUESTION 52
Which TWO statements correctly describe the behavior of Automatic Block Media Recovery in a Data Guard environment, for a corrupt block in the example tablespace encountered by a session logged in as the SH user?

A corrupt block on the primary database can be automatically recovered, using a block from a standby database with Real-Time Query enabled.

A corrupt block on the primary database is automatically recovered, using a block from a flashback log from a standby database with Real-Time Query enabled.

A corrupt block on a standby database with Real-Time Query enabled, is automatically recovered, using flashback logs from the standby database.

A corrupt block on a standby database with Real-Time Query enabled, can be automatically recovered, using a block from the primary database.

A corrupt block on the primary database is automatically recovered, using a block from a flashback log from the primary database.

NEW QUESTION 53
Your Data Guard configuration consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled
4. Redo transport mode is synchronous
5. Protection mode is maximum availability
6. The Data Guard broker is used
You notice that the standby destination fails to acknowledge reception of redo within net_timeout period of time.
Which is true in this scenario?

Real-time query will be disabled on the physical standby.

The protection mode will automatically change to Maximum Performance.

Synchronous redo transport mode connections to the standby database are terminated.

The physical standby database instance is shut down by the Data Guard broker.

NEW QUESTION 54
Which FOUR database parameters might be affected by or influence the creation of standby databases?

DB_NAME

ARCHIVE_LAG_TARGET

db_file_name_convert

COMPATIBLE

FALSERVER

STANDBY_ARCHIVE_DEST

NEW QUESTION 55
Your Data Guard configuration consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled
4. Redo transport mode is synchronous
5. Protection mode is maximum availability
6. The Data Guard broker is used
You notice that the standby destination fails to acknowledge reception of redo within net_timeout period of time.
Which is true in this scenario?

Real-time query will be disabled on the physical standby.

The protection mode will automatically change to Maximum Performance.

Synchronous redo transport mode connections to the standby database are terminated.

The physical standby database instance is shut down by the Data Guard broker.

NEW QUESTION 56
Which three are true concerning database states after a successful switchover?

The new primary database will be open read-write.

If the former primary database became a logical standby database it will be in mount state.

If the former primary database became a logical standby database it will be open read-write.

If the former primary database became a physical standby database it will be in the same state as the former physical standby database.

If the former primary database became a physical standby database it will always be open readonly.

The former primary database will always be open.

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

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

They can be used to skip CREATE TABLE commands.

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

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

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

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

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

NEW QUESTION 58
Which feature is available when monitoring a Data Guard configuration using Enterprise Manager Cloud Control, but is not available using DGMGRL or by using SQL?

Analyzing the dmon process trace file

Creating a broker configuration before creating the databases

Viewing a logical standby database apply lag

Automatic creation of standby redo logs

Performing a verify operation

NEW QUESTION 59
The Oracle database 19c Observer is currently running on host1 and you wish to have it running on host2.
Examine this list of possible steps:
1) Stop the observer on host1
2) Disable Fast-Start Failover
3) Update the broker configuration with the new observer hostname
4) Enable Fast-Start Failover
5) Start the Observer on host2
Which contains the minimum required steps to move the observer to host2?

Execute tasks 1 and 5

Execute only task 5

Execute tasks 1, 3, and 5

Execute tasks 1, 2, 3, 4, and 5

NEW QUESTION 60
You must configure on Oracle Data …….
1. A primary database
2. Three Physical Standby Databases
Examine these requirements:
A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

FASTSYNC and Maximum Protection

ASYNC and Maximum Performance

FASTSYNC and Maximum Availability

SYNC and Maximum Protection

NEW QUESTION 61
Which TWO statements are true for Data Guard environments with multi-tenant databases?

A multi-tenant standby database can have fewer pluggable databases than the primary container database.

Different pluggable databases within a logical standby database may have different guard statuses.

The Data Guard broker automatically opens all pluggable databases of a primary database after a role change operation.

The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

NEW QUESTION 62
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 63
On your logical standby database, you specified these rules:

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

Which is TRUE regarding the execution of the UNSKIP procedure?

It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

It deletes both the SQL Apply filters.

It succeeds but the SQL Apply filters are not deleted.

It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.

It returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.

NEW QUESTION 64
You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:

Which three statements are true regarding the execution of the command?

The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance.

The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.

The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.

The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.

The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.

The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.

NEW QUESTION 65
Examine the Data Guard configuration: DGMGRL> show configuration;
Configuration – Animals
Protection Mode: MaxPerformance
Databases:
dogs- Primary database
sheep – Physical standby database
cats- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
What can you conclude based on this error?

The redo transport mode is set to async for the standby database Sheep.

The redo transport mode is set to asyn: for the standby database Cats.

The redo transport mode is set to async for both standby databases.

Cats is a snapshot standby database.

Oracle 1z1-076 Exam Syllabus Topics:

Topic	Details
Topic 1	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 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 4	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 6	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 7	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 8	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.