Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Oracle 1z0-076 Practice Exam with Questions & Answers | Set: 2

Questions 11

You created two remote physical standby databases using SQL and RMAN.

The primary database is a four-instance RAC database and each physical standby database has two instances.

Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.

Consider these operational requirements:

• The ability to manage multiple standby databases with a single tool

• The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases

• The automation of failovers to a specified target standby database

Which TWO tools can be used to fulfill these requirements7

Options:
A.

RMAN

B.

SQL*Plus

C.

CRSCTL

D.

Enterprise Manager Cloud Control

E.

DGMGRL

F.

SRVCTL

G.

GDCCTL

Oracle 1z0-076 Premium Access
Questions 12

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

Options:
A.

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

B.

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

C.

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

D.

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

E.

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

Questions 13

Which TWO statements are true about database parameters for databases in a Data Guard environment?

Options:
A.

If DB_RECOVERY_FILE_DEST is specified, then LOG_ARCHIVE_DEST_n is not required for local archive logs.

B.

The databases that are part of a Data Guard configuration must have different DB_UNIQUE_NAME initialization parameters.

C.

COMPATIBLE must have identical values for primary and standby databases.

D.

LOG_FILE_NAME_CONVERT applies to online redo logs and archived logs.

E.

DB_FILE_NAME_CONVERT is only required if the standby database is on the same host as the primary database.

Questions 14

You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:

DGMGRL> SHOW CONFIGURATION;

Configuration - DRSolution

Protection Mode: MaxPerformance

Databases:

Close_by - Primary database

FS_inst - Far Sync

Far_away - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

What is true concerning this configuration?

Options:
A.

The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.

B.

The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the Close_by primary database is not able to do so.

C.

The Far Sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.

D.

The Close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.

E.

The Far Sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.

Questions 15

You are planning to perform block comparison using the dbms comp package:

1z0-076 Question 15

Which TWO statements are true?

Options:
A.

The databases should be at least mounted before block comparison.

B.

Logical standby databases can be the target database for the dbms_dbcomp.dbcomp procedure.

C.

It requires that the DB_LOST_WKITE_protect initialization parameter be enabled.

D.

You can monitor the progress of an ongoing block comparison operation by querying VS SES SION_LONGOPS.

E.

It can be used to detect lost writes and inconsistencies between the primary database and the cascaded standbys.

Questions 16

Examine the Data Guard configuration:

DGMGRL> show configuration;

Configuration - Animals

Protection Mode: MaxAvailability

Databases:

dogs - Primary database

sheep - Snapshot standby database

cats - Physical 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.

Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?

Options:
A.

DGMGRL> edit database dogs set property LogxptMode=sync;

B.

DGMGRL> edit database dogs set property LogXptMode=sync;

  DGMGRL> edit database cats set property LogXptMode=sync;

C.

DGMGRL> edit database cats set property LogXptMode=sync;

D.

DGMGRL> edit database dogs set property LogxptMode=sync;

  DGMGRL> edit database sheep set property LogxptMode=sync;

E.

DGMGRL> edit database dogs set property LogXptMode=sync;

  DGMGRL> edit database sheep set property LogxptMode=sync;

  DGMGRL> edit database cats set property LogXptMode=sync;

F.

DGMGRL> edit database sheep set property LogXptMode=sync;

Questions 17

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?

Options:
A.

a primary database with one logical standby database

B.

a primary database with two logical standby databases

C.

a primary database with one physical standby database

D.

a primary database with two physical standby databases

E.

A primary database with one logical and one physical standby database

Questions 18

Which two factors can cause an increase in redo transport lag?

Options:
A.

The size of the online redo log files on the standby database.

B.

The size of the standby redo log files on the primary database.

C.

Increase in network latency between the primary database and a redo transport destination.

D.

The size of the online redo log files on the primary database.

E.

Increase in redo generation rate on the primary database.

Questions 19

Your Data Guard environment contains a four-instance RAC primary database whose SID is PROD and a RAC physical standby database whose std is PROD_SBY.

Examine the command executed on a node of the primary database cluster to create a service OLTPWORKLOAD that the applications will use to connect to the database when it is in the FRlMARYTclatabase role:

srvctl add service -db PROD -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150

The service is then started

Consider this list of tasks:

1. On a node of the standby database cluster execute:

srvctl add service -db PROD_SBY -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150

2. On the primary database, create the oltpworkload database service using the dbms_service.create_service procedure.

3. Configure tap for clients in the tnsnames.ora files.

4. Make sure clients use the OLTPWORKLOAD service to connect to the database instances.

5. On the standby database, create the oltpworkload database service using the dbms_service.create_servi;l procedure.

Identify the required steps to configure and use Transparent Application Failover (taf).

Options:
A.

4

B.

2,3,4

C.

5

D.

1.4

E.

3,4

F.

1,3,4

Questions 20

Which three statements are true about snapshot standby databases?

Options:
A.

A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the primary database, will succeed.

B.

A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed.

C.

A resize command to extend the size of a datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed.

D.

A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the physical standby database, will succeed.

E.

A resize command to extend the size of a datafile in the snapshot standby database, which was created in the primary database, will succeed.

Exam Code: 1z0-076
Certification Provider: Oracle
Exam Name: Oracle Database 19c: Data Guard Administration
Last Update: Jul 15, 2025
Questions: 107

Oracle Related Exams

How to pass Oracle 1z0-591 - Oracle Business Intelligence Foundation Suite 11g Essentials Exam
Oracle Free Access
Get Oracle Full Access

Oracle Free Exams
Oracle Free Exams
Examstrack offers comprehensive free resources and practice tests for Oracle exams.