Free 1Z0-066 Exam Dumps PDF Preview

Question 1

Multiple choice

Which three are prerequisites for enabling Fast-Start Failover?

A
The Fast-Start Failover target standby database must receive REDO directly from the primary database
B
Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.
C
Flashback Database must be enabled only on the Fast-Start Failover target standby database.
D
The configuration must be operating in either Maximum Performance or Maximum Availability mode
E
The configuration must be operating in either Maximum Performance or Maximum Protection mode
F
The Data Guard environment must be managed by the Data Guard Broker.

Reveal answer details Close answer details

Correct answersB, D, F

Question 2

Multiple choice

Examine the Data Guard configuration:

Identify two possible reasons for this error.

A
The FastStartFailoverTarget property is not set on Sheep.
B
The FastStartFailoverTarget property is not set on Dogs.
C
The FastStartFailoverTarget property is not set on DogsFSI.
D
The LogXptMode property is set to ASYNC on Dogs.
E
The RedoRoutes property is not set on Dogs
F
The RedoRoutes property is not set on DogsFSI

Reveal answer details Close answer details

Correct answersA, D

Question 3

Multiple choice

Examine the Data Guard configuration:

Configuration Status: SUCCESS

Which two are true?

A
The observer must run on host ol5.example com and is currently not running.
B
The observer will reinstate Sheep automatically after a failover, if required.
C
The observer will mark another standby database as the failover target if the original failover target becomes unavailable.
D
The observer will detect if the primary database is unable to accept new connections
E
The former primary database will not be reinstated automatically alter a failover.

Reveal answer details Close answer details

Correct answersB, E

Question 4

Multiple choice

Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

A
Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
B
Put the primary database into archivelog mode
C
Startup nomount the standby database instance.
D
Configure Oracle Net connectivity on the primary host to the standby database instance.
E
Establish user equivalence for the database software owner between the primary host and standby host.

Reveal answer details Close answer details

Correct answersC, D, E

Question 5

Multiple choice

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

A
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.
B
Backups of archived redo logs taken on a physical standby are interchangeable with a primary.
C
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
D
Backups of control files taken on a physical standby are not interchangeable with a primary.
E
Backups of data files taken on a physical standby are interchangeable with a primary.

Reveal answer details Close answer details

Correct answersB, C, E

Question 6

Multiple choice

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

A
Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
B
Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
C
Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE
D
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.
E
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

Reveal answer details Close answer details

Correct answersA, B

Question 7

Single choice

A customer has these requirements for their potential 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:

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

A
EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT
DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET
PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION
MODE AS MAXAVAILABILITY
B
EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC
fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET
PROTECTION MODE AS MAXPROTECTION
C
EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1
SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT CONFIGURATION SET
PROTECTION MODE AS MAXAVAILABILITY;
D
EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT
DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1.
FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT
CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Reveal answer details Close answer details

Correct answerA

Question 8

Single choice

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?

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.

Reveal answer details Close answer details

Correct answerD

Question 9

Multiple choice

Which four database parameters might be affected by or influence the creation of standby databases?

A
DB_NAME
B
ARCHIVE_LAG_TARGET
C
COMPATIBLE
D
DB_FILE_NAME_CONVERT
E
DB_UNIQUE_NAME
F
FAL_SERVER
G
STANDBY_ARCH1VE_DEST

Reveal answer details Close answer details

Correct answersA, D, E, F

Question 10

Single choice

You have a Data Guard broker configuration consisting of:

1. A primary database
2. One local physical standby database
3. One far sync instance
4. A remote physical standby database

The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.

What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

A
Use the DGMGRL utility to register the configuration with the Enterprise manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored.
B
Discover the primary database as a target in Enterprise Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored.
C
Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.
D
Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.
E
Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.

Reveal answer details Close answer details

Correct answerE

Question 11

Multiple choice

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

A
Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
B
Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
C
Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE
D
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.
E
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

Reveal answer details Close answer details

Correct answersA, B

Question 12

Multiple choice

Examine the Data Guard configuration:

Which three will be true after a switchover to Dogs?

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

Reveal answer details Close answer details

Correct answersB, C, E

Question 13

Single choice

Examine this query and its output:

Which are true?

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 o17.example com
E
The observer is not running, but should run on o17 example.com.

Reveal answer details Close answer details

Correct answerA

Question 14

Multiple choice

Which two statements are true regarding Data Guard Broker?

A
It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby
B
It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
C
it can be used to perform failovers and switchovers.
D
It can be used to create and manage standby databases.
E
It can be used to monitor redo transport and log apply services.

Reveal answer details Close answer details

Correct answersB, C

Question 15

Multiple choice

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

A
The primary database must have FORCE LOGGING enabled.
B
The primary database must be in archive log 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

Reveal answer details Close answer details

Correct answersA, B

Question 16

Multiple choice

Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

A
Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
B
Put the primary database into archivelog mode
C
Startup nomount the standby database instance.
D
Configure Oracle Net connectivity on the primary host to the standby database instance.
E
Establish user equivalence for the database software owner between the primary host and standby host.

Reveal answer details Close answer details

Correct answersC, D, E

Question 17

Multiple choice

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 ways to start the observer successfully

A
Set the Observer Override property to TRUE before starting the observer
B
Create a broker configuration and enable Fast-Start Failover before starting the observer
C
Start the observer using a different observer configuration file.
D
start the observer in a different working directory.
E
Enable Fast-Start Failover before starting the observer

Reveal answer details Close answer details

Correct answersC, D

Question 18

Multiple choice

Which three statements are true about Data Guard configurations?

A
All databases in one Data Guard environment must have the same database name.
B
VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.
C
For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
D
When using the Data Guard Broker, an spfile is not required.
E
Up to 30 physical standby databases may exist within one configuration.
F
The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread

Reveal answer details Close answer details

Correct answersA, E, F

Question 19

Multiple choice

You edit the DGConnectldentifier database property using the edit database set property DGMGRL command

Which two are effects of this change?

A
The fal_client database initialization parameter on all standby databases is updated with the new value.
B
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.
C
The fal_client database initialization parameter for the specified database is updated with the new value
D
The broker configuration must be disabled and then enabled to use the new connection property.
E
The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value

Reveal answer details Close answer details

Correct answersA, B

Question 20

Single choice

You must configure an Oracle Data Guard environment consisting of:

1. A primary database

2 One Physical Standby Database

3. One Logical Standby Database

You must meet these requirements:

1. Primary database availability should not be compromised by the availability of the standby databases.

2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database.

Which redo transport mode and which protection mode would you configure to meet these requirements?

A
SYNC AFFIRM and Maximum Protection
B
SYNC NOAFFIRM and Maximum Protection
C
SYNC AFFIRM and Maximum Availability
D
SYNC NOAFFIRM and Maximum Availability
E
ASYNC and Maximum Performance

Reveal answer details Close answer details

Correct answerC

Question 21

Multiple choice

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

A
Fast-Start Failover is not yet enabled for this Data Guard configuration
B
The observer configuration file is marked read-only.
C
There is already an observer running for this Data Guard configuration.
D
There is another observer running for a Data Guard configuration which uses the same observer configuration file
E
The broker configuration has not yet been created.

Reveal answer details Close answer details

Correct answersB, D

Question 22

Multiple choice

Which two Data Guard features require the use of flashback database by the broker?

A
Read-Mostly physical standby implementations
B
Far Sync Instances
C
Fast-Start Failover
D
Real Time Query
E
Snapshot Standby databases

Reveal answer details Close answer details

Correct answersC, E

Question 23

Single choice

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?

A
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.
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 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.

Reveal answer details Close answer details

Correct answerA

Question 24

Multiple choice

Examine the Data Guard configuration:

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

A
Sheep will be in the disabled state.
B
Sheep will be in the enabled state.
C
Dogs will be in the disabled state and has to be manually reinstated
D
The configuration will be in Maximum Performance mode.
E
The configuration will be in Maximum Availability mode.

Reveal answer details Close answer details

Correct answersB, C, D

Question 25

Multiple choice

Which three are true about disabling of the Data Guard Broker management of databases in a configuration and the effects of doing this? (Choose three.)

A
The configuration transport mode may be modified while the entire configuration is disabled from broker management.
B
Database properties may be modified when that database is disabled from broker management.
C
A standby database that is the fast start failover target, may be disabled from broker management only by using the disable database DGMGRL command.
D
The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.
E
The only way to disable broker management of a far sync instance is to use the disable configuration DGMGRL command.

Reveal answer details Close answer details

Correct answersB, C, D

Explanation

References:
https://docs.oracle.com/cd/B28359_01/server.111/b28295/cli.htm#i1005955

Question 26

Multiple choice

Which four database parameters might be affected by or influence the creation of standby databases?

A
DB_NAME
B
ARCHIVE_LAG_TARGET
C
COMPATIBLE
D
DB_FILE_NAME_CONVERT
E
DB_UNIQUE_NAME
F
FAL_SERVER
G
STANDBY_ARCH1VE_DEST

Reveal answer details Close answer details

Correct answersA, D, E, F

Question 27

Single choice

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

What is true concerning this configuration?

A
The Close_by primary database instance forwards redo to the FSjnst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.
B
The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
C
The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FSjnst Far Sync instance.
D
The far sync instance will not forward redo to the Far_away physical standby because Fast-Stan: Failover is disabled
E
The FSjnst 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 answer details Close answer details

Correct answerA

Question 28

Multiple choice

Which two are true about management of a far sync instance when using the Data Guard Broker?

A
A far sync instance is in a disabled state in the broker configuration immediately after adding it
B
A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.
C
Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.
D
A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

Reveal answer details Close answer details

Correct answersA, B

Question 29

Multiple choice

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

A
a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
B
A Logical Standby Database can be converted to a Snapshot Standby Database.
C
A Logical Standby Database can cascade redo to a terminal destination
D
A Snapshot Standby Database can be a fast-start failover target
E
A Physical Standby Database can be converted into a Logical Standby Database.

Reveal answer details Close answer details

Correct answersB, E

Question 30

Multiple choice

Which three statements are true about Far Sync instances?

A
The Data Guard Broker must be used to deploy and manage Far Sync instances.
B
They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.
C
A primary database can ship redo directly to multiple Far Sync instances.
D
They use as spfile, a standby controlfile, and standby redo logs.
E
They work with any protection level.

Reveal answer details Close answer details

Correct answersA, B, D

Question 31

Multiple choice

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?

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

Reveal answer details Close answer details

Correct answersD, E

Free 1Z0-066 Exam Dumps Preview

Oracle Database 12c: Data Guard Administrator

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16

QUESTION 17

QUESTION 18

QUESTION 19

QUESTION 20

QUESTION 21

QUESTION 22

QUESTION 23

QUESTION 24

QUESTION 25

QUESTION 26

QUESTION 27

QUESTION 28

QUESTION 29

QUESTION 30

QUESTION 31

VOL	TYPE	QUESTIONS
1	Single choice	7
2	Multiple choice	24