2026 BraindumpStudy Oracle 1z1-076 Dumps and Exam Test Engine [Q64-Q84]

4/5 - (2 votes)

2026 BraindumpStudy Oracle 1z1-076 Dumps and Exam Test Engine

Oracle 1z1-076 DUMPS WITH REAL EXAM QUESTIONS

Q64. Which THREE are among the various tasks performed by the Data Guard Monitor (DMON) process?

performing role transitions when switchover requests are made

maintaining information about all members of the broker configuration in binary configuration files.

activating role-based services appropriately in the various database instances of the configuration, based on the database role

communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required

communicating with dkon processes in other database instances that are part of the broker configuration

Q65. 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

Q66. You must design an Oracle Data Guard configuration for a DSS database that meets these permanent requirements:
1. Creating and maintaining bitmap indexes should not impact the performance of the primary database.
2. Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest of databases?

a primary database with one logical standby database

a primary database with two logical standby databases

a primary database with one physical standby database

a primary database with two physical standby databases

A primary database with one logical and one physical standby database

Q67. Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?

Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both the Primary and the Standby.

Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host.

Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.

Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection descriptor on the clients to use that service.

Q68. Which three are true about using RMAN in a Data Guard environment?

A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.

Backups of data files taken on a physical standby are interchangeable with a primary.

A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.

Backups of control files taken on a physical standby are not interchangeable with a primary.

Backups of archived redo logs taken on a physical standby are interchangeable with a primary.

Q69. Your Data Guard environment contains a primary database and three standby databases with these attributes:
1. prod : Primary database
2. prod_prq : Physical standby database with real-time query enabled used by reporting applications
3. prod_lsby: Logical standby database used by DSS
4. PROD_SSBY: Snapshot standby database used for Real Application Testing Which TWO can be used to prevent clients from connecting to the wrong database instance?

Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.

Establish Oracle Net connectivity to the primary database instance from all the standby database instances.

Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.

Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.

Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.

Q70. Which THREE statements are TRUE about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

Their usage will always have a performance impact on the primary database.

Their creation requires that a LOG archive_dest_n parameter be defined in the standby that points back to the primary.

If the CACHE option is set then the size of the cache must be at least 100.

Their usage may have a performance impact on the physical standby database if the CACHE size is too small.

They must have the NOORDEK and CACHE options set.

Q71. 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

Q72. 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:

Q73. 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.

Q74. You are licensed to use Oracle Active Data Guard.
Which TWO statements are true after enabling block change tracking on a physical standby database?

It starts the RVWR process on the physical standby database instance.

It starts the CTWR process on the primary database instance.

It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database is converted.

It starts the CTWR process on the physical standby database instance.

It allows fast incremental backups to be offloaded to the physical standby database.

It allows fast incremental backups to be taken on the primary database.

Q75. 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.

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

PL/SQL blocks that you run on Active Data Guard standby databases can be always redirected to and run on the primary database.

Read-mostly reporting applications that use global temporary tables for storing temporary data can be offloaded.

You might have to use sequences with global temporary tables to support read-mostly applications by using Active Data Guard.

The DDL operations on private temporary tables are transparently redirected to the primary database.

The DML operations on a standby can be transparently redirected to and run on the primary database

Q77. Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?

If the primary database is not a container database, then a standby may be a container database.

If the primary database is a container database, then a physical standby may be a non-container database.

If the primary database is a container database, then a logical standby may be a non-container database.

All broker actions execute at the root container for container databases.

After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.

Q78. 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.

Q79. 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.

Q80. Which three are prerequisites for enabling Fast-Start Failover?

A static service name must be configured only for the Fast-Start Failover target standby database.

The Fast-Start Failover target standby database may receive REDO either synchronously or asynchronously when the configuration operates in Maximum Performance mode.

Flashback Database must be enabled on the primary database.

The Fast-Start Failover target standby database must receive REDO synchronously when the configuration operates in Maximum Availability mode.

Flashback Database must be enabled on the Fast-Start Failover target standby database.

Q81. Which three are prerequisites for enabling Fast-Start Failover?

The Data Guard environment must be managed by the Data Guard Broker.

Flashback Database must be enabled only on the Fast-Start Failover target standby database.

You can specify only one standby database as the fast-start failover target.

The configuration must be operating in either Maximum Performance or Maximum Protection mode.

The maximum protection mode can be used, but with two or more standby databases.

Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

Q82. Which THREE steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

Configure Oracle Net connectivity on the primary host to the standby database instance.

Establish user equivalence for the database software owner between the primary host and standby host.

startup nomount the standby database instance.

Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME name parameter.

Put the primary database into archivelog mode.

Q83. 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

Q84. 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 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.

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.

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

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

Oracle 1z1-076 Exam Syllabus Topics:

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