Oracle 1z0-076 Real 2025 Braindumps Mock Exam Dumps [Q54-Q76]

NO.54 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.

NO.55 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.

NO.56 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.

NO.57 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.

NO.58 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.

NO.59 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

NO.60 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.

NO.61 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.

NO.62 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.

NO.63 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.

NO.64 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?
A)

B)

C)

Option A

Option B

Option C

Option D

NO.65 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.

NO.66 Which THREE are true about using flashback database in a Data Guard environment?

It may be used to flash back a physical standby that receives redo from a far sync instance.

It may not be used to flash back a primary database after a failover to a physical standby.

When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically.

You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption.

When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically.

You can use it when real-time apply is enabled in case the phylt may not be used to flash back a primary database after a failover to a logical standby.

NO.67 Which three types of backups offload …….. with the primary database in a data Guard

Control files

Broker configuration files

Password files

Data files

Online logs

Archive logs

NO.68 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.

NO.69 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

NO.70 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.

NO.71 You are using Data Guard in conjunction with Global Database Services.
You have a Data Guard Broker configuration called Sales and a GDS pool called Prod.
Which three are true concerning the management of the broker configuration when using GDS?

DGMGRL may be used to add the Sales configuration to the Prod pool in gds.

Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services.

DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool.

Adding a database to the Sales configuration with DGMGRL automatically adds the database to the Prod Pool.

Adding a database to the Sales configuration with DGMGRL requires that the Sales configuration be disabled first. It must then be enabled after the new database is added to the configuration.

NO.72 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.

NO.73 Which four factors can influence the rate of SQL apply on a logical standby database?

the number of PREPAER processes

the number of coordinator processes on the standby database instance

the number of full table scans performed by SQL apply

the size of the undo tablespace on the logical standby database

the number of applier processes

the size of the shared pool

NO.74 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.

NO.75 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.

NO.76 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:

Leave a Reply Cancel reply