Name: Oracle 1Z0-066 Exam
Brand: Pass4Success
SKU: 1Z0-066
Price: 69.00 USD
Availability: InStock
Rating: 4.9 (51 reviews)

Disscuss Oracle 1Z0-066 Topics, Questions or Ask Anything Related

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!

Free Oracle 1Z0-066 Exam Actual Questions

Note: Premium Questions for 1Z0-066 were last updated On 04-11-2022 (see below)

Question #1

You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:

DGMGRL> SHOW CONFIGURATION

Configuration DRSolution

Protection Mode: MaxPerformance

Databases:

Close_by Primary database

FS_inst Far Sync

Far_away Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

What is true concerning this configuration?

AThe Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.

BThe far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.

CThe close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.

DThe far sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.

EThe FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so.

Reveal Solution

Correct Answer: A

An Oracle Data Guard far sync instance is a remote Oracle Data Guard destination that accepts redo from the primary database and then ships that redo to other members of the Oracle Data Guard configuration. A far sync instance manages a control file, receives redo into standby redo logs (SRLs), and archives those SRLs to local archived redo logs, but that is where the similarity with standbys ends. A far sync instance does not have user data files, cannot be opened for access, cannot run redo apply, and can never function in the primary role or be converted to any type of standby database.

References:

https://docs.oracle.com/database/121/SBYDB/create_fs.htm

Question #2

After converting your physical standby database to a logical database, you get an error:

DGMGRL> show configuration

Configuration proddg

Protection Mode: MaxPerformance

Databases:

prod Primary database

prodsby Physical standby database

Error: ORA-16810 multiple errors or warnings detected for database

Fast-Start Failover: DISABLED

Configuration Status:

ERROR

How can you rectify the error?

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

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

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

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

Reveal Solution

Correct Answer: D

You can reenable the standby database or reset the primary database state to ONLINE to fix the inconsistencies.

References:

https://docs.oracle.com/cd/B19306_01/server.102/b14230/cli.htm

Question #3

Which four requirements can be met by deploying a logical standby database? (Choose four.)

ASupport for workloads requiring additional indexes.

BIt can be used to create additional schemas.

CIt can be used to create additional tables.

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

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

FSupport for workloads requiring additional materialized views.

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

Reveal Solution

Correct Answer: A, C, E, G

A: DDL Statements supported by a Logical Standby Database include:

ALTER INDEX

CREATE INDEX

DROP INDEX

C: DDL Statements supported by a Logical Standby Database include:

CREATE TABLE

DROP TABLE

Question #4

A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.

As a result of this, you decide that an upgrade may not use logical standby databases.

Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary? (Choose three.)

AThe upgrade requires downtime until the upgrade of the standby is completed.

BThe broker must be disabled during the upgrade.

CWith manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.

DThe upgrade requires downtime until the upgrade of the primary is completed.

EThe new release of the Oracle Software must be installed on both the primary and standby database hosts.

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

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

Reveal Solution

Correct Answer: B, D, E

B: Disable the broker's management of the configuration and then stop the broker.

E: On the primary database install the newer release of the Oracle software, and on the logical standby database, install the newer release of the Oracle software.

Question #5

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.

Switchovers or failovers are possible due to testing or in case of a disaster.

Clients use local TNSNAMES.ORA files to define connection strings to the database instances.

Which three will prevent clients from connecting to the wrong database instances? (Choose three.)

AClient TNS entries for the databases use the correct service names for the intended service.

BA service name is registered with the local listener of each database instance.

COracle Net connectivity to the primary database instance must be established on all the standby database instances.

DThe LOCAL_LISTENER parameter on the primary database instance must always be set.

EThe standby database services must be defined statically with the Listeners running on the standby database hosts.

FThe DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.

GThe client applications must use the correct TNS entries when requesting connections to the database instances.

Reveal Solution

Correct Answer: C, D, G

References:

https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/configuring-data-guard-standby-databases-in-oracle-RAC.html#GUID-65F87F2F-6602-4673-B971-4AEE3B4F7B4D

https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG010

https://docs.oracle.com/cd/E11882_01/network.112/e41945/concepts.htm#NETAG177

Unlock Premium 1Z0-066 Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now

Oracle 1Z0-066 Exam Questions

Free Oracle 1Z0-066 Exam Actual Questions

Note: Premium Questions for 1Z0-066 were last updated On 04-11-2022 (see below)