Jun-2022 Oracle 1Z0-066 Certification Real 2022 Mock Exam [Q22-Q41]

NEW QUESTION 22
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.

NEW QUESTION 23
Which two are true about management of a far sync instance when using the Data Guard Broker? (Choose two.)

A far sync instance is in a disabled state in the broker configuration immediately after adding it.

A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.

Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.

A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created.

NEW QUESTION 24
Which two statements are true regarding Data Guard Broker?

It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.

It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.

It can be used to perform failovers and switchovers.

It can be used to create and manage standby databases.

It can be used to monitor redo transport and log apply services.

NEW QUESTION 25
Your Data Guard environment has one physical standby database using Real-Time Query.
Two sentences have been created by these SQL statements:
create sequence a global;
create sequence b session;
Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL;
SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

Option A

Option B

Option C

Option D

NEW QUESTION 26
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.

NEW QUESTION 27
Which three statements are true about Global Sequences when connected to a physical standby
database with Real-Time Query enabled?

if the CACHE option is set then the size ofthe cache must be at least 100

Their creation requires that a LOG_ARCH IVE_DEST n parameter be defined in the standby that points
back to their primary

Their usage will always have a performance impact on the primary database.

Their usage may have a performance impact on the physical standby database ifthe CACHE size is too
small

They must have the NOORDER and CACHE options set.

NEW QUESTION 28
Which three statements are true about Data Guard configurations? (Choose three.)

All databases in one Data Guard environment must have the same database name.

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.

For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.

When using the Data Guard Broker, an spfile is not required.

Up to 30 physical standby databases may exist within one configuration.

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.

NEW QUESTION 29
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?

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

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

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

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

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

NEW QUESTION 30
Which three statements are true about Data Guard configurations?

All databases in one Data Guard environment must have the same database name.

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.

For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.

When using the Data Guard Broker, an spfile is not required.

Up to 30 physical standby databases may exist within one configuration.

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.

NEW QUESTION 31
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.

NEW QUESTION 32
Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment? (Choose two.)

A flash recovery area must be configured.

The database must be in MOUNT state.

The database must be in ARCHIVELOG mode.

A far sync instance must be configured to flash back a standby when the primary has been flashed back.

The Data Guard Broker must be used.

NEW QUESTION 33
Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
————— ———————– —————- —————— BYSTANDER cats NO O17.example.com 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.

NEW QUESTION 34
Which two are true about offloading backups to a physical standby database in a Data Guard environment?
(Choose two.)

The standby database must be registered in an RMAN catalog after the primary database has been registered.

The standby database cannot be registered in an RMAN catalog if the primary database has not been registered.

Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.

The standby database must be registered in an RMAN catalog before the primary database has been registered.

NEW QUESTION 35
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. Three Physical Standby Databases
You must meet these requirements:
1. A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. 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 NOAFFIRM and Maximum Protection

SYNC NOAFFIRM and Maximum Availability

ASYNC and Maximum Performance

SYNC AFFIRM and Maximum Availability

SYNC AFFIRM and Maximum Protection

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

DB_NAME

ARCHIVE_LAG_TARGET

COMPATIBLE

DB_FILE_NAME_CONVERT

DB_UNIQUE_NAME

FAL_SERVER

STANDBY_ARCHIVE_DEST

NEW QUESTION 37
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
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary 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.

NEW QUESTION 38
Which two are true about the creation of a Data Guard Broker configuration? (Choose two.)

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.

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

Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the
DB_NAME parameter.

Put the primary database into archivelog mode

Startup nomount the standby database instance.

Configure Oracle Net connectivity on the primary host to the standby database instance.

Establish user equivalence for the database software owner between the primary host and standby
host.

NEW QUESTION 40
Examine the Data Guard configuration:
DGMGRL > show configuration;
Configuration-Animals
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
dogsfsl -Far Sync
sheep- Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
An attempt to enable fast-start failover raises an eror:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover Failed.
Identify two possible reasons for this error.

The FastStartFailoverTarget property is not set on Sheep.

The FastStartFailoverTarget property is not set on Dogs.

The FastStartFailoverTarget property is not set on DogsFS1.

The LogXptMode property is set to ASYNC on Dogs.

The RedoRoutes property is not set on Dogs.

The RedoRoutes property is not set on DogsFS1.

NEW QUESTION 41
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.

Leave a Reply Cancel reply