06 February, 2023

Top Tips Of Update 1z0-066 Free Practice Questions

Act now and download your Oracle 1z0-066 test today! Do not waste time for the worthless Oracle 1z0-066 tutorials. Download Update Oracle Oracle Database 12c: Data Guard Administration exam with real questions and answers and begin to learn Oracle 1z0-066 with a classic professional.

Free 1z0-066 Demo Online For Oracle Certifitcation:

Page: 1 / 15

Total 184 questions Full Exam Access

Question 1

You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?

The standby database must have supplemental logging enabled.

The primary database must have FORCE LOGGING enabled

The DG_BROKER_START parameter must be set to TRUE for both database instances.

The primary database must have supplemental logging enabled.

A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.

Question 2

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

DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.

Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.

Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.

A pluggable database within a multi-tenant standby database can have a different open mode than the container database

A pluggable database within a multi-tenant standby database can have a different database role than the container database.

Question 3

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 4

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

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

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

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

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.

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

Question 5

Examine the Data Guard configuration: DGMGRL> show configuration Configuration-Animals
Protection Mode: MaxAvailability Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration Dogs - (*) Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED Configuration Status: WARNING And the fast-start failover configuration:
DGMGRL> show fast_start failover; Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dogs
Observer: 017.example.com Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate: TRUE Observer Reconnect 10 seconds Observer Override: FALSE
Configurable Failover Conditions Hearth Conditions: Corrupted Controlfile YES Inaccessible Logfile NO
Stuck Archiver NO Datafile Offline YES Oracle error Conditions
ORA-01578: ORACLE data block corrupted (file # %s, block # %s) And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats;
LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.

MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.

MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep

Open Dogs and let the broker reinstate Dogs automatically.

Question 6

Which three statements are true about snapshot standby databases?

Snapshot standby databases may be used for rolling release upgrades.

if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.

Flashback logs are used to convert a snapshot standby database back into a physical standby database.

a snapshot standby database can have Real-Time Query enabled

A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Question 7

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

Which three will be true after a switchover to Dogs?

Sheep will be an enabled logical standby database.

Cats will be an enabled physical standby database

Dogs will be the primary database

Sheep will be a disabled logical standby database

Cats will be a disabled physical standby database

Question 8

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

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

Sheep will be in the disabled state.

Sheep will be in the enabled state.

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

The configuration will be in Maximum Performance mode.

The configuration will be in Maximum Availability mode.

Question 9

Which three are prerequisites for enabling Fast-Start Failover?

The Fast-Start Failover target standby database must receive REDO directly from the primary database

Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

Flashback Database must be enabled only on the Fast-Start Failover target standby database.

The configuration must be operating in either Maximum Performance or Maximum Availability mode

The configuration must be operating in either Maximum Performance or Maximum Protection mode

The Data Guard environment must be managed by the Data Guard Broker.

Question 10

Examine the Data Guard configuration after an accidental switchover to Sheep:
1Z0-066 dumps exhibit

Which three will be true after a switchover to Dogs?

Sheep will be a disabled logical standby database.

Sheep will be an enabled logical standby database.

Cats will be a disabled physical standby database that can be manually enabled.

Cats will be an enabled physical standby database.

Dogs will be the primary database.

Question 11

You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2 Three Physical Standby Databases
You must meet these requirements:
✑ A designated physical standby database should become the primary database automatically whenever the primary database falls
✑ The chosen protection mode should provide the highest level of protection
possible without violating the other requirement
Which redo transport mode and protection mode would you configure to meet these requirements?

SYNC NOAFFRIM and Maximum Protection

SYNC NOAFFIRM and Maximum Availability

ASYNC and Maximum Performance

SYNC AFFIRM and Maximum Availability

SYNC AFFIRM and Maximum Protection

Question 12

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

Which three will be true after a switchover to Dogs?

Sheep will be an enabled logical standby database.

Cats will be an enabled physical standby database

Dogs will be the primary database

Sheep will be a disabled logical standby database

Cats will be a disabled physical standby database

Question 13

Which two statements are true about Real-Time Query?

Setting STANDBY_MAX_DATA_DELAY =0 requires synchronous redo transport.

Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened READ ONLY.

Real-Time Query sessions can be connected to a Far Sync instance.

Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

Question 14

Which four requirements can be met by deploying a logical standby database?

Support for workloads requiring additional indexes.

it can be used to create additional schemas.

it can be used to create additional tables.

It must have the same physical structure as the primary database.

it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.

Support for workloads requiring additional materialized views.

it can be used for Real Application Testing without affecting the disaster recovery capabilities.

Question 15

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 reasons for this error

Fast-Start Failover is not yet enabled for this Data Guard configuration

The observer configuration file is marked read-only.

There is already an observer running for this Data Guard configuration.

There is another observer running for a Data Guard configuration which uses the same observer configuration file

The broker configuration has not yet been created.

Question 16

Which two are true about the creation of a Data Guard Broker configuration?

in a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.

A primary database profile may be added to the configuration prior to creating the primary database.

A standby database profile may be added to the configuration prior to creating that standby database.

A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.

A newly created broker configuration is in the disabled state

Question 17

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.

Page: 1 / 15

Total 184 questions Full Exam Access