Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

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

Oracle 1z0-076 Premium Access     Download Demo    
Page: 1 / 4
Total 107 questions

Which THREE statements are true…….. open in real time query mode, which becomes a new.

A.

All sessions are disconnected and all

B.

Sessions that are using database links

C.

All current buffers can be retained.

D.

Sessions that have long running queries can be retained.

E.

User sessions and Current Buffers are maintained by default.

F.

User sessions can be retained.

Examine the procedure that you plan to execute on your logical standby:

SQL> EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'DML', schema_name => 'HR', object_name => 'EMPLOYEE');

What is a prerequisite for execution of this procedure?

A.

Change the redo transport mode if necessary to ASYNC.

B.

Stop SQL Apply on the logical standby database.

C.

Execute the DBMS_LOGSTDBY.APPLY_SET procedure to record errors that might cause SQL Apply to stop.

D.

Stop redo transport to the logical standby database.

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.

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.

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.

Which three statements are true about redo transport?

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.

Which THREE are among the various tasks performed by the Data Guard Monitor (DMON) process?

A.

performing role transitions when switchover requests are made

B.

maintaining information about all members of the broker configuration in binary configuration files.

C.

activating role-based services appropriately in the various database instances of the configuration, based on the database role

D.

communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required

E.

communicating with dkon processes in other database instances that are part of the broker configuration

Which THREE statements are true about Far Sync instances?

A.

The Data Guard Broker must be used to deploy and manage Far Sync instances.

B.

They work with any protection level.

C.

They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.

D.

They use an spfMe, a standby controlfile, and standby redo logs.

E.

A primary database can ship redo directly to multiple Far Sync instances.

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

Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?

A.

If the primary database is not a container database, then a standby may be a container database.

B.

If the primary database is a container database, then a physical standby may be a non-container database.

C.

If the primary database is a container database, then a logical standby may be a non-container database.

D.

All broker actions execute at the root container for container databases.

E.

After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.

Which TWO are TRUE about offloading backups to a physical standby database in a Data Guard environment?

A.

The standby database must be registered in an RMAN catalog after the primary database has been registered.

B.

The standby database can not be registered in an RMAN catalog if the primary database has not been registered.

C.

Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.

D.

The standby database must be registered in an RMAN catalog before the primary database has been registered.