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

  1. Home
  2. Oracle
  3. Oracle Certification
  4. 1z0-076 - Oracle Database 19c: Data Guard Administration

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

Go to page:
Question # 4

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

Which three statements are true about snapshot standby databases?

A.

A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the primary database, will succeed.

B.

A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed.

C.

A resize command to extend the size of a datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed.

D.

A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the physical standby database, will succeed.

E.

A resize command to extend the size of a datafile in the snapshot standby database, which was created in the primary database, will succeed.

Full Access
Question # 6

Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

A.

Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners.

B.

Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE.

C.

Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.

D.

Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.

E.

Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host.

Full Access
Question # 7

Your current Data Guard environment consists of:

    A primary database containing no abstract data types used for user tables.

    Two separate remote physical standby databases used for reporting.

Examine these requirements for adding a new standby database to this Data Guard environment:

    The new standby database must provide a disaster recovery solution.

    There must be minimal additional performance overheads on the primary database.

    The new standby database may require additional indexes and materialized views not present in the primary.

    New tables or schemas may be required in the standby database that are not present in the primary.

What would you recommend to fulfill these requirements?

A.

A physical standby database with synchronous redo transport and Real-Time Query enabled.

B.

A physical standby database with asynchronous redo transport and Real-Time Query enabled.

C.

A logical standby database with synchronous redo transport and redo apply on.

D.

A logical standby database with synchronous redo transport and SQL apply on.

E.

A logical standby database with asynchronous redo transport and SQL apply on.

Full Access
Question # 8

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?

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

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps