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

1z0-076 PDF

$38.5

$109.99

3 Months Free Update

  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

1z0-076 PDF + Testing Engine

$61.6

$175.99

3 Months Free Update

  • Exam Name: Oracle Database 19c: Data Guard Administration
  • Last Update: Jun 18, 2024
  • Questions and Answers: 70
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

1z0-076 Engine

$46.2

$131.99

3 Months Free Update

  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

1z0-076 Practice Exam Questions with Answers Oracle Database 19c: Data Guard Administration Certification

Question # 6

Examine the fast-start failover configuration:

1z0-076 question answer

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

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?

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.

Full Access
Question # 8

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

Examine the Data Guard configuration:

1z0-076 question answer

What happens if you issue "switchover to sheep;" at the DGMGRL prompt?

A.

The switchover succeeds and Cats becomes the new failover target.

B.

It results in an error indicating that a switchover is not allowed.

C.

The switchover succeeds but Dogs needs to be reinstated.

D.

The switchover succeeds and Fast-Start Failover is suspended.

E.

The switchover succeeds and Dogs becomes the new failover target.

Full Access
Question # 10

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

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

Full Access
Question # 11

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

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.

Full Access
Question # 13

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

Which TWO statements are true about configuring Oracle Net Service in a Data Guard environment?

A.

A static service must be registered with the local listener to enable DGMGRL to restart instances during the course of broker operations.

B.

Install the oracle-database-preinstall-19c package to set the kernel parameters for Oracle Net based on the Data Guard best practice guidelines.

C.

Installing the oracle-database-preinstall-19c package is NOT sufficient to set up operating system kernel parameters for Oracle Net.

D.

Enterprise Manager does not require static service registration to restart instances during the course of broker operations.

E.

It is necessary to use the failover clause for an address_list with multiple address lists in the tnsnames.ora file.

Full Access
Question # 15

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

Which three are prerequisites for using Data Guard Broker?

A.

The primary and standby databases must run the same version of the Oracle Database server.

B.

Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances.

C.

DG_BROKEB_START must be set to TRUE for a database instance before adding the database to the broker configuration.

D.

If any database in the configuration is a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration.

E.

The broker configuration files for a RAC database must reside in shared storage accessible by all the RAC database instances.

F.

A statically defined listener end-point must be registered with the local listener on the servers hosting the 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 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 # 19

Examine the Data Guard configuration:

1z0-076 question answer

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

Which three are true concerning database states after a successful switchover?

A.

The new primary database will be open read-write.

B.

If the former primary database became a logical standby database it will be in mount state.

C.

If the former primary database became a logical standby database it will be open read-write.

D.

If the former primary database became a physical standby database it will be in the same state as the former physical standby database.

E.

If the former primary database became a physical standby database it will always be open readonly.

F.

The former primary database will always be open.

Full Access
Question # 21

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