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

1z0-076 Questions and Answers

Question # 6

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.

Full Access
Question # 7

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.

Full Access
Question # 8

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).

A.

4

B.

2,3,4

C.

5

D.

1.4

E.

3,4

F.

1,3,4

Full Access
Question # 9

Which four factors can influence the rate of SQL apply on a logical standby database?

A.

the number of PREPAER processes

B.

the number of coordinator processes on the standby database instance

C.

the number of full table scans performed by SQL apply

D.

the size of the undo tablespace on the logical standby database

E.

the number of applier processes

F.

the size of the shared pool

Full Access
Question # 10

Examine the Data Guard configuration:

DGMGRL> show configuration;

Configuration - Animals

Protection Mode: MaxAvailability

Databases:

dogs - Primary database

cats - Snapshot standby database

sheep - Snapshot standby database

Fast-Start Failover: DISABLED

Configuration Status:

ORA-01034: ORACLE not available

ORA-16625: cannot reach database "dogs"

DGM-17017: unable to determine configuration status

ou wish to perform a failover to sheep. Which command, or sequence of commands, should you issue to the broker before executing failover to sheep; using the broker?

A.

DGMGRL> convert database sheep to physical standby;

B.

DGMGRL> convert database cats to physical standby;

C.

DGMGRL> convert database sheep to physical standby;

DGMGRL> edit configuration set protection mode as maxperformance;

DGMGRL> convert database sheep to physical standby;

D.

DGMGRL> convert database cats to physical standby;

E.

None, because you can directly failover to a Snapshot Standby Database.

Full Access
Question # 11

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
Question # 12

A customer asks for your recommendation regarding this requirement:

1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.

2. We want zero data loss in case of a disaster involving the loss of one component.

3. We want to do Real Application Testing occasionally on the Standby Database.

Which solution, if any, satisfies these requirements?

A.

These requirements cannot be met.

B.

A physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing

C.

A snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing

D.

A far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing

Full Access
Question # 13

You are licensed to use Oracle Active Data Guard.

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

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.

Full Access
Question # 14

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 # 15

Which three are prerequisites for enabling Fast-Start Failover?

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.

Full Access
Question # 16

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?

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.

Full Access
Question # 17

Which two are true about database roles in an Oracle Data Guard configuration?

A.

A Physical Standby Database can be converted into a Logical Standby Database.

B.

A Snapshot Standby Database can be a fast-start failover target.

C.

A Logical Standby Database can be converted to a Snapshot Standby Database.

D.

A Logical Standby Database can cascade redo to a terminal destination.

E.

A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

Full Access
Question # 18

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

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.

Full Access
Question # 19

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

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.

Full Access
Question # 20

Which three are true about using RMAN in a Data Guard environment?

A.

Backups of archived redo logs taken on a physical standby are interchangeable with a primary.

B.

Backups of control files taken on a physical standby are not interchangeable with a primary.

C.

A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.

D.

Backups of data files taken on a physical standby are interchangeable with a primary.

E.

A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.

Full Access
Question # 21

Attempting to start the observer raises an error:

DGMGRL> start observer;

DGM-16954: Unable to open and lock the Observer configuration file

Failed.

Identify two possible ways to start the observer successfully.

A.

Enable Fast-Start Failover before starting the observer.

B.

Start the observer in a different working directory.

C.

Create a broker configuration and enable Fast-Start Failover before starting the observer.

D.

Start the observer using a different observer configuration file.

E.

Set the ObserverOverride property to TRUE before starting the observer.

Full Access
Question # 22

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 # 23

Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

A.

The configuration will be in Maximum Performance mode.

B.

Sheep will be in the enabled state.

C.

Sheep will be in the disabled state.

D.

Dogs will be in the disabled state and has to be manually reinstated.

E.

The configuration will be in Maximum Availability mode.

Full Access
Question # 24

Which two are true concerning the configuring of Flashback database in a Data Guard environment?

A.

It permits a physical standby database to be converted to a snapshot standby database.

B.

It is required in order for a snapshot standby database to be converted to a physical standby database.

C.

It enables the use of far sync instances.

D.

It permits a primary database that was disabled after failover to be reinstated as a standby.

E.

It is a prerequisite for the use of Fast Start Failover.

Full Access
Question # 25

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

Full Access
Question # 26

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

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.

Full Access
Question # 27

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

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.

Full Access
Question # 28

Which TWO statements are true about Far Sync instances?

A.

They do not work with Logical Standby databases.

B.

They work in Maximum Availability mode.

C.

They do not work with Snapshot Standby databases.

D.

They work in Maximum Performance mode.

E.

They work in Maximum Protection mode.

Full Access
Question # 29

Your Data Guard environment consists of these components and settings:

A primary database supporting an OLTP workload

A remote physical standby database

Real-time query is enabled

The redo transport mode is set to SYNC

The protection mode is set to Maximum Availability

Which two statements are true regarding the DelayMins database property for the standby database?

A.

It can only be enabled for a configuration in Maximum Availability mode.

B.

It allows user errors on the primary to be recovered by using the physical standby database.

C.

It can only be enabled for a configuration in Maximum Performance mode.

D.

It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

E.

It allows logical corruptions on the primary to be recovered by using the physical standby database.

F.

It enables you to bypass the default network timeout interval specified for the standby redo transport destination.

Full Access
Question # 30

Examine this validate command:

DGMGRL> VALIDATE DATABASE VERBOSE "";

Which THREE statements are TRUE?

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.

Full Access
Question # 31

Examine the fast-start failover configuration:

A.

A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database

B.

If South_Sales develops a problem and cannot be the target of a failover, the broker automatically changes the fast-start failover target to one of the other candidate targets.

C.

The observer will initiate a failover when the primary database is unable to produce local archived redo log files.

D.

You must disable fast-start failover first to change the fast-start failover target to East sales.

E.

The observer is running.

Full Access
Question # 32

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

A.

RMAN

B.

SQL*Plus

C.

CRSCTL

D.

Enterprise Manager Cloud Control

E.

DGMGRL

F.

SRVCTL

G.

GDCCTL

Full Access