Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Free and Premium Oracle 1z0-076 Dumps Questions Answers

Page: 1 / 8
Total 107 questions

Oracle Database 19c: Data Guard Administration Questions and Answers

Question 1

Which TWO statements are true about Real-Time Query?

Options:

A.

Setting standby_max_data_delay=0 requires synchronous redo transport.

B.

Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

C.

Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.

D.

Real-Time Query sessions can be connected to a Far Sync instance.

E.

A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

Buy Now
Question 2

Which two are prerequisites for configuring flashback database for Oracle 19c databases, in a Data Guard environment?

Options:

A.

A far sync instance must be configured to flash back a standby when the primary has been flashed back.

B.

A fast recovery area must be configured.

C.

The database must be in ARCHTVELOG mode.

D.

The Data Guard real-time apply feature must be enabled.

E.

The data guard broker must be used.

Question 3

Which three statements are true about redo transport?

Options:

A.

With synchronous redo transport, LGWR ships redo directly to RFS processes on the standby database instances and waits for an acknowledgment.

B.

An RFS process on a standby database instance may receive redo from an archiver process on the primary database instance to perform archive gap resolution.

C.

With asynchronous redo transport, TTnn processes may read redo from the log buffer or from standby redo logs on the primary database.

D.

Multiple RFS processes may receive redo on one standby database instance.

E.

Multiple RFS processes may receive redo on one far sync instance.

Question 4

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?

Options:

A.

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

B.

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

C.

It will execute successfully on an Oracle 19c physical standby database while Real Time Query is active.

D.

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.

E.

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

F.

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.

Question 5

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?

Options:

A.

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

B.

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.

C.

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.

D.

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.

Question 6

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.

Question 7

Examine the Data Guard configuration:

DGMGRL> show configuration;

Configuration - Animals

Protection Mode: Max Availability

Databases:

dogs - Primary database sheep

- Physical standby database cats

- Physical standby database

Fast-Start Failover: DISABLED

Configuration Status: SUCCESS

An attempt to enable fast-start failover raises an error:

DGMGRL> enable fast_start failover;

Error: ORA-16693: requirements not met for enabling fast-start failover

Failed.

Identify three possible reasons for this error.

Options:

A.

The fastStartFailoverTarget property is not set on Dogs.

B.

The LogxptModr property is set to async on Sheep while Sheep is the target standby database.

C.

The LogXptMode property is set to FASTSYNC on Cats while Sheep is the target standby database.

D.

The LogXptMode property is set to async on Dogs.

E.

The LogXptMode property is set to fastsync on Dogs.

Question 8

Which three statements are true about Data Guard database modes and states?

Options:

A.

Force Logging Mode is not required for a primary database but is recommended.

B.

The Primary Database can operate in noarchivelog mode.

C.

A Logical Standby Database can be in MOUNT state while applying changes.

D.

Databases in a Data Guard Configuration need not operate in Flashback Logging mode.

E.

A primary database may ship redo directly to more than nine standby databases.

Question 9

Which TWO statements are true regarding Data Guard Broker?

Options:

A.

It can be used to create and manage standby databases.

B.

It can be used to perform failovers and switchovers.

C.

It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.

D.

It can be used to monitor redo transport and log apply services.

E.

It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.

Question 10

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.

Question 11

Your Data Guard environment consists of these components and settings:

1. A primary database

2. Two remote physical standby databases

3. The redo transport mode is set to sync

4. Real-time query is enabled for both standby databases

5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases

You notice an increase in redo apply lag time on both standby databases.

Which two would you recommend to reduce the redo apply lag on the standby databases?

Options:

A.

Increase the size of standby redo log files on the standby databases.

B.

Decrease the redo log file size on the primary database.

C.

Increase the number of standby redo log files on the standby databases.

D.

Lower DB_BLOCK_CHECKING to MEDIUM or low on the standby databases.

E.

Increase the size of the buffer cache on the physical standby database instances.

Question 12

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?

Options:

A.

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

B.

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

C.

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

D.

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

E.

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.

Question 13

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?

Options:

A.

It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

B.

It deletes both the SQL Apply filters.

C.

It succeeds but the SQL Apply filters are not deleted.

D.

It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.

E.

It returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.

Question 14

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.

Question 15

A customer asks you to propose the most appropriate solution for this set of requirements:

    We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.

    We want to generate reports from the proposed standby database at the same time that it is used for data protection.

    Developers may need to test occasionally on a copy of the live database

Which TWO solutions would you recommend?

Options:

A.

A snapshot standby database with synchronous redo transport

B.

A physical standby database with real-time query enabled

C.

A logical standby database with real-time query enabled

D.

A physical standby database with real-time apply enabled

E.

A logical standby database with real-time apply enabled

Question 16

Which four requirements can be met by deploying a logical standby database?

Options:

A.

Support for workloads requiring additional materialized views.

B.

It must have the same physical structure as the primary database.

C.

It can be used to create additional tables.

D.

It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.

E.

It can be used for Real Application Testing without affecting the disaster recovery capabilities.

F.

Support for workloads requiring additional indexes.

G.

It can be used to create additional schemas.

Question 17

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution?

Options:

A.

Ensure that supplemental logging is enabled on the primary database.

B.

Ensure that no ROWID data types are contained in the primary database.

C.

Ensure that no BFILE LOB data types are contained in the primary database.

D.

Do not perform any nologging operations on the primary.

E.

Ensure that flashback is enabled on the primary database.

Question 18

Which two statements are true when using non-rolling release upgrades in a Data Guard environment?

Options:

A.

The compatible parameter on a standby database that is applying redo, must be equal to or greater than the compatible parameter on the primary that is shipping redo to that standby.

B.

Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a logical standby database.

C.

Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a physical standby database.

D.

During the upgrade of a logical standby database, standby redo log files must reside on O/S file systems.

E.

User equivalence must be established for the owner of the Oracle software on the affected hosts prior to the upgrade.

Question 19

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:

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 20

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

Options:

A.

The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

B.

Itbackups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

C.

The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

D.

Primary and physical standby databases may use different virtual recovery catalogs in the same physical recovery catalog.

E.

It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

Question 21

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

Options:

A.

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

B.

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

C.

startup nomount the standby database instance.

D.

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

E.

Put the primary database into archivelog mode.

Question 22

Which TWO statements are true for Data Guard environments with multi-tenant databases?

Options:

A.

A multi-tenant standby database can have fewer pluggable databases than the primary container database.

B.

Different pluggable databases within a logical standby database may have different guard statuses.

C.

The Data Guard broker automatically opens all pluggable databases of a primary database after a role change operation.

D.

The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

E.

The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

Question 23

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?

Options:

A.

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

B.

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

C.

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.

D.

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.

Question 24

Which FOUR database parameters might be affected by or influence the creation of standby databases?

Options:

A.

DB_NAME

B.

ARCHIVE_LAG_TARGET

C.

db_file_name_convert

D.

COMPATIBLE

E.

FALSERVER

F.

STANDBY_ARCHIVE_DEST

Question 25

Which three statements are true……. With no Oracle Streams or Goldengate configured?

Options:

A.

It is recommended to have them on the...

B.

Only standby databases can write redo....

C.

The LGWR process writes to them on ....

D.

They are required on a logical standby for real-time apply

E.

They are required on a physical standby for real-time apply.

F.

They are required only for synchronous redo transport

Question 26

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

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.

Question 27

Which two statements are true regarding asynchronous redo transport in a Data Guard

Options:

A.

This transport mode satisfies the minimum requirements for Maximum Availability data protection mode.

B.

A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.

C.

This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.

D.

Real-time query performance on a physical standby database improves for current read requests when using this transport mode.

E.

The performance of SQL apply on a logical standby database always improves when using this transport mode.

Question 28

Which three are true about using Flashback database through role transitions in a Data Guard environment?

Options:

A.

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.

B.

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.

C.

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.

D.

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.

E.

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

Question 29

Examine this validate command:

DGMGRL> VALIDATE DATABASE VERBOSE "";

Which THREE statements are TRUE?

Options:

A.

The command performs a comprehensive set of database checks prior to a role change.

B.

The command performs a comparison of SPFILE entries between the primary database and a specified standby database.

C.

The command performs network connectivity checks between members of a broker configuration.

D.

The command can be used for a logical standby database.

E.

The command uses information available in various Oracle Data Guard views as well as the Automatic Diagnostic Repository.

Question 30

You are licensed to use Oracle Active Data Guard.

Which TWO statements are true after enabling block change tracking on a physical standby database?

Options:

A.

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

B.

It starts the CTWR process on the primary database instance.

C.

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

D.

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

E.

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

F.

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

Question 31

Which three are prerequisites for enabling Fast-Start Failover?

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Question 32

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;

Page: 1 / 8
Total 107 questions