Labour Day Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. Oracle
  3. Oracle Database 12c
  4. 1z0-066 - Oracle Database 12c: Data Guard Administrator

Oracle 1z0-066 Oracle Database 12c: Data Guard Administrator Exam Practice Test

Note! Following 1z0-066 Exam is Retired now. Please select the alternative replacement for your Exam Certification. The new exam code is 1z0-076
Page: 1 / 11
Total 112 questions
Get 1z0-066 Full Access Download 1z0-066 PDF

Oracle Database 12c: Data Guard Administrator Questions and Answers

Question 1

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

Options:

A.

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.

B.

the LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

C.

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.

D.

A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

E.

A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

Question 2

You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAILABILITY using Enterprise Manager Cloud Control.

Which two are true about this change? (Choose two.)

Options:

A.

If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.

B.

The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.

C.

Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.

D.

Fast start failover can be enabled when making the chance.

E.

Real time apply will be automatically turned on.

Question 3

Your Data Guard environment has two remote physical standby databases.

Client applications use the local naming method to connect to the primary database instance.

You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.

Which will fulfill this requirement?

Options:

A.

Create a database service on each standby database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

B.

Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

C.

Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

D.

Set the DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

Question 4

The Oracle database 12c Observer is currently running on host1 and you wish to have it running on host2.

Examine this list of possible steps:

1) Stop the observer on host1.

2) Disable Fast-Start Failover.

3) Update the broker configuration with the new observer hostname.

4) Enable Fast-Start Failover.

5) Start the Observer on host2.

Which contains the minimum required steps to move the observer to host2?

Options:

A.

Execute only task 5.

B.

Execute tasks 1, 3, and 5.

C.

Execute tasks 1, 2, 3, 4, and 5.

D.

Execute tasks 1 and 5.

Question 5

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database? (Choose two.)

Options:

A.

It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

B.

The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

C.

The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

D.

It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

E.

Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog.

Question 6

Which two are prerequisites for creating a standby database using Enterprise Manager cloud control? (Choose two.)

Options:

A.

The primary database must have FORCE LOGGING enabled.

B.

The primary database must be in archivelog mode.

C.

A backup of the primary database must exist.

D.

The primary host and the proposed standby database host must run the same operating system.

E.

The primary database instance must be started using an SPFILE.

F.

The primary database must have flashback enabled.

Question 7

Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled? (Choose three.)

Options:

A.

If the CACHE option is set then the size of the cache must be at least 100.

B.

Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary.

C.

Their usage will always have a performance impact on the primary database.

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 NOORDER and CACHE options set.

Question 8

A Data Guard environment has this configuration and these attributes:

1. A primary database

2. A Physical Standby Database named sbdb

3. The configuration is in maximum availability protection mode.

Then sbdb is converted to a snapshot standby database.

When two statements are true? (Choose two.)

Options:

A.

Sdbd can still apply redo.

B.

The recovery point objective increases.

C.

The protection mode is lowered to maximum performance.

D.

The recovery time objective increases.

E.

Sbdb can still receive redo

Question 9

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?

Options:

A.

Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service.

B.

Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.

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.

Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host.

Question 10

Examine the Data Guard configuration:

DGMGRL> show configuration:

Configuration ‒ Animals

Protection Mode: MaxAvailability

Databases:

cats ‒ Primary database

dogs ‒ Physical standby database

sheep ‒ Logical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

Which three will be true after a switchover to Dogs? (Choose three.)

Options:

A.

Sheep will be an enabled logical standby database.

B.

Cats will be an enabled physical standby database.

C.

Dogs will be the primary database.

D.

Sheep will be a disabled logical standby database.

E.

Cats will be a disabled physical standby database.

Question 11

A customer has these requirements for their proposed Data Guard implementation:

1. Zero data loss must still be guaranteed through the loss of any one configuration component.

2. The primary database must be protected against a regional disaster.

3. Performance overheads on the primary should be minimized as much as possible given these requirements.

4. Downtime on the primary database for any reason must be kept to a minimum.

Components referred to in the broker commands are:

Question # 11

Which Data Guard broker commands are needed to implement these requirements?

Options:

A.

EDIT DATABASE prima SET PROPERTY REDOROUTES=’ (LOCAL:physt1 FASTSYNC)’;EDIT DATABASE prima SET PROPERTY REDOROUTES=’ (LOCAL:fs1 SYNC)’;EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=’ (prima:physt2 SYNC)’;EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

B.

EDIT DATABASE prima SET PROPERTY REDOROUTES=’ (LOCAL:fs1 ASYNC)’;EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=’ (prima:physt FASTSYNC)’;EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION

C.

EDIT DATABASE prima SET PROPERTY REDOROUTES=’ (LOCAL:fs1 SYNC)’;EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=’ (prima:physt ASYNC)’;EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

D.

EDIT DATABASE prima SET PROPERTY REDOROUTES=’ (LOCAL:physt1 FASTSYNC)’;EDIT DATABASE prima SET PROPERTY REDOROUTES=’ (LOCAL:fs1 FASTSYNC)’;EDIT FAR_SYNC fs1 SET PROPERTY REDOROUTES=’ (prima:physt2 ASYNC)’;EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Question 12

Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard? (Choose three.)

Options:

A.

It checks that supplemental logging is turned on if there is a logical standby database in the configuration.

B.

It verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.

C.

It checks that the current data protection level is consistent with the broker’s configured data protection mode.

D.

It modifies the database configurable parameters to match the values set for the broker configuration.

E.

It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

Question 13

You administer a Data Guard environment consisting of a primary database and three physical standby databases.

One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.

The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.

The physical standby database is the only standby that is a mandatory destination.

The broker configuration operates in MAXIMUM PERFORMANCE mode.

Which ARCHIVELOG DELETION POLICY should be set, so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?

Options:

A.

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

B.

CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

C.

CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;

D.

CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;

E.

CONFIGURE ACHIVELOG DELETION POLICY TO NONE;

Question 14

You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload that meets these permanent requirements:

1. Data loss is not permitted.

2. Read-only applications should not connect to the primary database instance.

Additionally, there are these requirements, only one of which is ever done at any one time:

3. It should be possible to apply and test designated patches with a minimum amount of downtime.

4. Upgrading to a new database release should be performed with the least possible amount of downtime.

5. New application software releases should be tested against an exact up-to-date replica of the production database.

You propose a primary database with one physical standby database configured in Maximum Protection mode.

Which requirements do you meet?

Options:

A.

2, 3, 4, and 5

B.

1, 2, 3, 4, and 5

C.

1 and 2

D.

only requirement 5

E.

only requirement 1

Question 15

Which two are true about rolling release upgrades in a Data Guard environment? (Choose two.)

Options:

A.

The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure.

B.

A physical standby database can be converted to a logical standby database temporarily.

C.

Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.

D.

The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.

E.

The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

Question 16

Examine this query and its output:

SQL> select fs_failover_status, fs_failover_current_target,

2 fs_failover_observer_present, fs_failover_oserver_host

3 from v$database:

FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET

------------------ --------------------------

BYSTANDER cats

FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST

---------------------------- -------------------------

NO ol7.example.com

Which are true?

Options:

A.

The observer is not connected to the database on which the query was executed.

B.

Cats is a bystander database.

C.

The observer is connected to the database on which the query was executed.

D.

The observer is currently running on ol7.example.com.

E.

The observer is not running, but should run on ol7.example.com.

Load More 1z0-066 Questions 
Page: 1 / 11
Total 112 questions
Get 1z0-066 Full Access Download 1z0-066 PDF