1. Home
  2. Oracle
  3. Oracle Database 19c
  4. 1z0-076
  5. Oracle Database 19c: Data Guard Administration Questions and Answers

Pass the Oracle Oracle Database 19c 1z0-076 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

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 # 2:

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 # 3:

Your Data Guard environment has one physical standby database using Real-Time Query. Two sequences have been created by these SQL statements:

Question # 3

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)

Question # 3

B)

Question # 3

C)

Question # 3

D)

Question # 3

Options:
A.

Option A

B.

Option B

C.

Option C

D.

Option D

Questions # 4:

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

Options:
A.

To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

B.

To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

C.

A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

D.

A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

E.

The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

Questions # 5:

You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:

Question # 5

Which three statements are true regarding the execution of the command?

Options:
A.

The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance.

B.

The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.

C.

The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.

D.

The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.

E.

The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.

F.

The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.

Questions # 6:

A Data Guard environment has this configuration and these attributes:

    A primary database

    A physical standby database named sbdb

    The configuration is in maximum availability protection mode.

Then sbdb is converted to a snapshot standby database.

Which two statements are true?

Options:
A.

The recovery time objective increases.

B.

sbdb can still receive redo.

C.

The protection mode is lowered to maximum performance.

D.

sbdb can still apply redo.

E.

The recovery point objective increases.

Questions # 7:

Examine the Data Guard configuration after an accidental switchover to Sheep:

DGMGRL> show configuration;

Configuration - Animals

Protection Mode: MaxAvailability

Databases:

sheep - Primary database

dogs - Logical standby database

cats - Physical standby database (disabled)

ORA-16795: the standby database needs to be re-created

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

Which three statements will be true after a switchover to Dogs?

Options:
A.

Sheep will be a disabled logical standby database.

B.

Cats will be a disabled physical standby database that can be manually enabled.

C.

Sheep will be an enabled logical standby database.

D.

Dogs will be the primary database.

E.

Cats will be an enabled physical standby database.

Questions # 8:

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

Options:
A.

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

B.

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

C.

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

D.

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

E.

They must have the NOORDEK and CACHE options set.

Questions # 9:

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

Question # 9

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 # 10:

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

Options:
A.

Far Sync Instances

B.

Snapshot Standby databases

C.

Read-Mostly physical standby implementations

D.

Fast-Start Failover

E.

Real Time Query

Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions