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

1z0-076 Exam Dumps - Oracle Database 19c: Data Guard Administration

Go to page:
Question # 17

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

A.

DB_NAME

B.

ARCHIVE_LAG_TARGET

C.

db_file_name_convert

D.

COMPATIBLE

E.

FALSERVER

F.

STANDBY_ARCHIVE_DEST

Full Access
Question # 18

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?

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.

Full Access
Question # 19

Examine the following parameter settings of the physical standby database:

• STANDBY_FILE_MANAGEMENT=AUTO

• ENABLED_PDBS_ON_STANDBY=

During which TWO tasks are files automatically created in the physical standby database after structure changes on the primary database?

A.

Performing transportable tablespaces

B.

Adding or dropping a redo file group

C.

Adding a data file or creating a tablespace

D.

Creating a PDB from the existing PDB within the same CDB

E.

Renaming a data file in the primary database

Full Access
Question # 20

Suppose that you manage the following databases in your environment:

• boston: Primary database with a single PDB called DEVI

• london: Physical standby database protecting the PDB called DEVI

• orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source

You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:

Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?

A.

Open PDBI (remote clone source) in Read Only.

B.

Open PDBI (remote clone source) in Read Write.

C.

Set STANDBY_PDB_SOURCE_FILE_DIRECTORY to in the london database.

D.

Set standby_pdb_source_file_dblink to clone_link in the london database.

E.

Enable Active Data Guard in the _ondon database.

F.

Set STANDBY_FILE_MANAGEMENT to auto in the london database.

Full Access
Question # 21

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?

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.

Full Access
Question # 22

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

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.

Full Access
Question # 23

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

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.

Full Access
Question # 24

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?

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.

Full Access
Go to page: