16 October, 2019

Virtual Oracle 1z0-066 Item Pool

Master the 1z0-066 Oracle Database 12c: Data Guard Administration content and be ready for exam day success quickly with this Examcollection 1z0-066 practice. We guarantee it!We make it a reality and give you real 1z0-066 questions in our Oracle 1z0-066 braindumps.Latest 100% VALID Oracle 1z0-066 Exam Questions Dumps at below page. You can use our Oracle 1z0-066 braindumps and pass your exam.

Page: 1 / 15

Total 184 questions Full Exam Access

Question 1

You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration?

Archive logs on the primary database may be deleted once they are applied on all standby databases.

Archive logs on the primary database may be deleted once they are shipped on all standby databases.

The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.

The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.

Archive logs on the primary database may be deleted once they are archived locally to disk.

Question 2

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 3

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 4

A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?

Recover the datafile by using the RMAN RECOVER DATAFILE command

Restart the redo apply.

Restore the datafile by using the RMAN RESTORE DATAFILE command.

Stop the redo apply.

Recover the database by using the RMAN RECOVER DATABASE command.

Question 5

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 6

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 7

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

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.

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

To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

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

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

Question 8

Examine the Data Guard configuration: DGMGRL> show configuration;
Configuration -Animals Protection Mode MaxAvailability Databases
dogs- Primary database
cats- Snapshot standby database sheep- Snapshot standby database Fast-Start Failover DISABLED
Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs'1 DGM-17017 unable to determine configuration status
You wish to perform a failover to Sheep
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?

DGMGRL> convert database cats to physical standby,

DGMGRL> convert database sheep to physical standby;

DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby;

DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby;

None, because you can directly failover to a Snapshot Standby Database

Question 9

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 10

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?

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

The broker must be disabled during the upgrade

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

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

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

Redo Apply on the 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

A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?

a remote physical standby database with RedoRoutesvia a far sync instance

a snapshot standby database with synchronous redo transport

a physical standby database with real-time query enabled

a logical standby database

a read mostly implementation of a physical standby database

Question 12

Examine this query and its output:
1Z0-066 dumps exhibit

Which are true?

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

Cats is a bystander database.

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

The observer is currently running on o17.example com

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

Question 13

Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user?

Real Time Query must be enabled on the primary database

Real Time Query must be enabled on the physical standby database.

|f a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.

If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved

if a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.

If a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.

Question 14

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

Which three will be true after a switchover to Sheep?

Cats will be an enabled logical standby database

Cats will be a disabled logical standby database.

Dogs will be a logical standby database.

Dogs will be a physical standby database

Sheep will be the primary database.

Question 15

Which four factors can influence the rate of SQL apply on a logical standby database?

the size of the undo tablespace on the logical standby database

the number of full table scans performed by SQL apply

the number of coordinator processes on the standby database instance

the size of the shared pool

the number of APPLIER processes

the number of PREPARER processes

Question 16

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 17

Which two are prerequisites for creating a standby database using Enterprise Manager cloud control?

The primary database must have FORCE LOGGING enabled.

The primary database must be in archive log mode

A backup of the primary database must exist.

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

The primary database instance must be started using an SPFILE.

The primary database must have flashback enabled

Question 18

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 19

Which two are true about database roles in an Oracle Data Guard Configuration?

a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

A Logical Standby Database can be converted to a Snapshot Standby Database.

A Logical Standby Database can cascade redo to a terminal destination

A Snapshot Standby Database can be a fast-start failover target

A Physical Standby Database can be converted into a Logical Standby Database.

Question 20

You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control
Which two are true about this change?

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

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

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.

Fast start failover can be enabled when making the chance.

Real time apply will be automatically turned on.

Page: 1 / 15

Total 184 questions Full Exam Access