2026 1z1-076 Dumps PDF – 1z1-076 Real Exam Questions Answers [Q65-Q83]

NEW QUESTION 65
Which two statements are true regarding Data Guard environments in an Oracle Muti-tenant architecture?

Different redo transport methods can be configured for different pluggable databases within one Data Guard environment.

The Data Guard broker may be used for multi-tenant databases.

PDB_FILE_NAME CONVERT must be set to enable creation of standby databases if they are created on the same host as the primary.

Standby redo log files are required for each pluggable database that is protected with Data Guard.

A Data Guard environment with a multi-tenant primary database can operate in any Protection mode.

NEW QUESTION 66
A customer asks for your recommendation regarding this requirement:
1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.
2. We want zero data loss in case of a disaster involving the loss of one component.
3. We want to do Real Application Testing occasionally on the Standby Database.
Which solution, if any, satisfies these requirements?

These requirements cannot be met.

A physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing

A snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing

A far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing

NEW QUESTION 67
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 68
Which two are true about database roles in an Oracle Data Guard configuration?

A Physical Standby Database can be converted into a Logical Standby Database.

A Snapshot Standby Database can be a fast-start failover target.

A Logical Standby Database can be converted to a Snapshot Standby Database.

A Logical Standby Database can cascade redo to a terminal destination.

A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

NEW QUESTION 69
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 70
Which three are true about using Flashback database through role transitions in a Data Guard environment?

Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.

Logical standby databases retain their current role when you flash back through to a point in time before the switchover occurred which caused this database to become a logical standby.

Logical standby database roles are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.

Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.

Flashback database may not be used to undo a physical standby database activation.

NEW QUESTION 71
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 72
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 73
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.

NEW QUESTION 74
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 75
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 76
Your Data Guard environment has one physical standby database using Real-Time Query. Two sequences have been created by these SQL statements:

Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL; SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?

NEW QUESTION 77
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 78
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 79
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 80
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which set of actions will fulfill this requirement?

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

Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

Set the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

NEW QUESTION 81
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.

NEW QUESTION 82
Examine the Data Guard configuration:

What happens if you issue “switchover to sheep;” at the DGMGRL prompt?

The switchover succeeds and Cats becomes the new failover target.

It results in an error indicating that a switchover is not allowed.

The switchover succeeds but Dogs needs to be reinstated.

The switchover succeeds and Fast-Start Failover is suspended.

The switchover succeeds and Dogs becomes the new failover target.

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