Sep-2025 Free Oracle 1z0-076 Exam Question Practice Exams [Q10-Q34]

Rate this post

Sep-2025 Free Oracle 1z0-076 Exam Question Practice Exams

Ace 1z0-076 Certification with 111 Actual Questions

Oracle 1z0-076 Exam Syllabus Topics:

Topic	Details
Topic 1	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 2	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 4	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 5	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 6	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 7	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 8	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.
Topic 9	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 10	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 11	Creating a Logical Standby Database: This topic guides users through the process of creating and managing a logical standby database, including SQL Apply filtering.

NEW QUESTION 10
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 11
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 12
Examine this validate command:
DGMGRL> VALIDATE DATABASE VERBOSE “<database name>”;
Which THREE statements are TRUE?

The command performs a comprehensive set of database checks prior to a role change.

The command performs a comparison of SPFILE entries between the primary database and a specified standby database.

The command performs network connectivity checks between members of a broker configuration.

The command can be used for a logical standby database.

The command uses information available in various Oracle Data Guard views as well as the Automatic Diagnostic Repository.

NEW QUESTION 13
Which two Data Guard features require the use of flashback database by the broker?

Far Sync Instances

Snapshot Standby databases

Read-Mostly physical standby implementations

Fast-Start Failover

Real Time Query

NEW QUESTION 14
Which two are true concerning the configuring of Flashback database in a Data Guard environment?

It permits a physical standby database to be converted to a snapshot standby database.

It is required in order for a snapshot standby database to be converted to a physical standby database.

It enables the use of far sync instances.

It permits a primary database that was disabled after failover to be reinstated as a standby.

It is a prerequisite for the use of Fast Start Failover.

NEW QUESTION 15
In Oracle Database 19c, you can set the value of database initialization parameters in a database using the EDIT DATABASE… SET PARAMETER Command:
DGMGRL> EDIT DATABASE ‘boston’ SET PARAMETER log_archive_trace – 1;
Which THREE statements are TRUE about the command?

The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.

The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.

The database must be available when the above command is run.

The value set using this command is directly stored in the broker configuration file.

The value set using this command is directly applied to the boston database.

NEW QUESTION 16
A customer has these requirements for their proposed Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:

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

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

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

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.

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

NEW QUESTION 18
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 19
Which three statements are true……. With no Oracle Streams or Goldengate configured?

It is recommended to have them on the…

Only standby databases can write redo….

The LGWR process writes to them on ….

They are required on a logical standby for real-time apply

They are required on a physical standby for real-time apply.

They are required only for synchronous redo transport

NEW QUESTION 20
Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

Primary and physical standby databases may use different virtual recovery catalogs in the same physical recovery catalog.

It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

NEW QUESTION 21
You detected an unrecoverable archive gap in your data guard environment. So, you need to roll standby.
forward in time without applying a large number of archive log files using this command:
RMAN> RECOVER STANDBY DATABASE FROM SERVICE-<primary database name>;
When running this command, which of the following steps can be performed automatically?
1. Remember all data file names on the standby.
2. Restart standby in nomount.
3. Restore controlfile from primary.
4. Mount standby database.
5. Rename data files from stored standby names.
6. Restore new data files to new names.
7. Recover standby.

2,3,5,6,7

2,3,6,7

1,3,5,6,7

1,2,3,4,5,6,7

1, 2,3,4,6,7

NEW QUESTION 22
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 23
You have a Data Guard Broker configuration called ‘Somewhere’ as shown:
DGMGRL> SHOW CONFIGURATION;
Configuration – Somewhere
Protection Mode: MaxPerformance
Databases:
Nearby – Primary database
FS – Far Sync
Farout – Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You then run this command:
DGMGRL> SHOW DATABASE ‘Nearby’ ‘InconsistentProperties’;
Which two are true about the output of this DGMGRL command?

A far sync instance cannot have inconsistent properties because it has no database.

It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.

Any inconsistency reported is on an instance-specific basis.

It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.

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

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

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

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

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

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

NEW QUESTION 25
You created a physical standby database prodsbyi from the primary database prod using SQL and RMAN. Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases?

A local net service name to enable connectivity to the PRODSBYI database instance must be defined on the primary database host.

The primary database must have supplemental logging enabled.

The LOG_ARCHIVE_DEST_n parameters with the service attribute set must be cleared.

The standby database must have supplemental logging enabled.

The primary database must have FORCE LOGGING enabled.

The DG_BROKER_START parameter must be set to TRUE for both database instances.

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

All sessions are disconnected and all

Sessions that are using database links

All current buffers can be retained.

Sessions that have long running queries can be retained.

User sessions and Current Buffers are maintained by default.

User sessions can be retained.

NEW QUESTION 27
Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution?

Ensure that supplemental logging is enabled on the primary database.

Ensure that no ROWID data types are contained in the primary database.

Ensure that no BFILE LOB data types are contained in the primary database.

Do not perform any nologging operations on the primary.

Ensure that flashback is enabled on the primary database.

NEW QUESTION 28
Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances?

Oracle Net connectivity to the primary database instance must be established on all the standby database instances.

The standby database services must be defined statically with the Listeners running on the standby database hosts.

The LOCAL_LISTENER parameter on the primary database instance must always be set.

The client applications must use the correct TNS entries when requesting connections to the database instances.

Client TNS entries for the databases use the correct service names for the intended service.

The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.

A service name is registered with the local listener of each database instance.

NEW QUESTION 29
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 30
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 31
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 32
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 33
Which two are prerequisites for configuring flashback database for Oracle 19c databases, in a Data Guard environment?

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

A fast recovery area must be configured.

The database must be in ARCHTVELOG mode.

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

The data guard broker must be used.

NEW QUESTION 34
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