09 February, 2023

Renovate 1z0-066 Exam Question For Oracle Database 12c: Data Guard Administration Certification

It is more faster and easier to pass the Oracle 1z0-066 exam by using Virtual Oracle Oracle Database 12c: Data Guard Administration questuins and answers. Immediate access to the Avant-garde 1z0-066 Exam and find the same core area 1z0-066 questions with professionally verified answers, then PASS your exam with a high score now.

Online Oracle 1z0-066 free dumps demo Below:

Page: 1 / 15

Total 184 questions Full Exam Access

Question 1

Which three are benefits of using the Data Guard Broker to manage standby databases?

it simplifies physical standby database creation

It provides an easy failover capability using a single command.

it coordinates database state transitions and updates database properties dynamically.

it automatically changes database properties after the protection mode for a configuration is changed

It provides an easy switchover capability using a single command.

It simplifies logical standby database creation.

Question 2

Examine the Data Guard configuration;
1Z0-066 dumps exhibit

What can you conclude based on this error?

Cats is a snapshot standby database

The redo transport mode is set to ASYNC for the standby database Sheep

The redo transport mode is set to ASYNC for both standby databases

The redo transport mode is set to ASYNC for the standby database Cats

Question 3

After converting your physical standby database to a logical database, you get an error:
1Z0-066 dumps exhibit

How can you rectify the error?

Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.

Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.

Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.

Reinstate both the primary and physical standby databases The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

Question 4

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?

Increase the size of the buffer cache on the physical standby database instances.

Increase the number of standby redo log files on the standby databases.

Decrease the redo log file size on the primary database.

Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.

Increase the size of standby redo log files on the standby databases.

Question 5

Which two statements are true for Data Guard environments with mufti-tenant databases?

Different pluggable databases within a logical standby database may have different guard statuses.

The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.

The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

A multi-tenant standby database can have fewer pluggable databases than the primary container database

Question 6

You must propose an Oracle Data Guard configuration tor 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?

2,3, 4, and 5

1,2, 3,4, and 5

1 and 2

only requirement 5

only requirement 1

Question 7

You edit the DGConnectldentifier database property using the edit database set property
DGMGRL command Which two are effects of this change?

The fal_client database initialization parameter on all standby databases is updated with the new value.

The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.

The fal_client database initialization parameter for the specified database is updated with the new value

The broker configuration must be disabled and then enabled to use the new connection property.

The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value

Question 8

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

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.

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

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

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

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

Question 9

Which two are true about rolling release upgrades in a Data Guard environment?

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

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

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

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

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

Question 10

A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows
As a result of this, you decide that an upgrade may use logical standby databases. Which two are true about upgrading Data Guard environments consisting of one logical
standby database running on a separate host from the primary?

The upgrade always requires downtown until the upgrade of the logical standby is completed

Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.

The upgrade always required downtime until the upgrade of the primary is completed

Using manual upgrade, catupgr.sql needs to run on the primary database only.

SQL Apply on the local standby database must be stopped while the primary database is upgraded.

Fast-Start Failover can be used to protect the primary database during the upgrade.

Question 11

Examine this list of possible steps:
1 Raise the compatibility level on both databases
2.Restart SQL Apply on the upgraded logical standby database 3 Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

5,2.4,3,6,1

1,5,2,4,6,3

5,2,4,6,3,1

4,6,5,2,3,1

5,2,4,1

Question 12

Examine the Fast-start configuration
1Z0-066 dumps exhibit

Oracle Error Conditions: (none) Which three are true?

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

An automatic failover will be initiated even if the target standby database lags behind the primary

The observer is running

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

The configuration operates in Maximum Availability mode

The configuration operates in Maximum Performance mode

Question 13

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

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

The new primary database will be open read-write.

The former primary database will always be open.

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

if the former primary database became a physical standby database it will always be open read-only.

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

Question 14

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?

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

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.

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.

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

Question 15

Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors: ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

Change the protection mode to Maximum Performance.

Increase the size of the buffer cache on the standby database instance.

Reduce I/O latency for the storage used by the primary database.

Change the protection mode to Maximum Protection.

Increase the network bandwidth between the primary and standby databases

Increase the number of standby redo log files on the primary database

Question 16

Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload 2 A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability
Which two are true regarding the DelayMins Database Property for the standby database?

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

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

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

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

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

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

Question 17

Examine the Data Guard configuration:
DGMGRL > show configuration; Configuration-Animals
Protection Mode MaxPerformance Databases
dogs-Primary database sheep-Snapshot standby database cats-Snapshot standby database
Fast-Start Failover: DISABLED Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Availability: DGMGDRL> edit configuration set protection mode as max availability;
Error ORA-16627 operation disallowed since no standby databases would remain to support protection mode Failed.
Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability.

DGMGRL> convert database sheep to physical standby;

DGMGRL> convert database cats to physical standby;

DGMGRL> edit database dogs set property LogXptMode= fastsync;

DGMGRL> edit database sheep set property LogXptMode= fastsync;

DGMGRL> edit database cats set property LogXptMode= sync;

Page: 1 / 15

Total 184 questions Full Exam Access