1Z0-066 Dumps for Pass Guaranteed – Pass 1Z0-066 Exam 2022 [Q29-Q52]

NO.29 Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxPerformance
Databases:
dogs Primary database
sheep Snapshot standby database
cats Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Availability:
DGMGDRL> edit configuration set protection mode as maxavailability;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
Identify two statements that you can execute, either one of which will enable successful raising of the protection mode to Maximum Availability. (Choose two.)

DGMGRL> convert database sheep to physical standby;

DGMGRL> convert database cats to physical standby;

DGMGRL> edit database dogs set property LogXptMode= fastsync;

DGMGRL> edit database sheep set property LogXptMode= fastsync;

DGMGRL> edit database cats set property LogXptMode= sync;

NO.30 Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered

backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

backups of data files taken on the logical standby database, if not connected to a recovery catalog

backups of control files taken on the logical standby database if not connected to a recovery catalog

NO.31 On your logical standby database, you specified these rules:

Which is true regarding the execution of the UNSKIP procedure?

it succeeds only if SQL apply is stopped before deleting the SQL Apply filter

it succeeds but the SQL Apply fitters are not deleted.

It deletes both the SQL Apply filters.

it returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added

it succeeds only if all DML statements executed on the primary have been applied on the logical standby

NO.32 Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment? (Choose three.)

backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered

backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

backups of data files taken on the logical standby database, if not connected to a recovery catalog

backups of control files taken on the logical standby database if not connected to a recovery catalog

NO.33 Which three are true concerning archive logs in a Data Guard Environment? (Choose three.)

A physical standby database instance chooses an appropriate location for writing its own standby archive logs automatically.

A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote logical standby database instance to which it routes redo, is not reachable.

A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote physical standby database instance to which it routes redo, is not reachable.

A logical standby database instance writes online redo logs.

A logical standby database chooses an appropriate location for writing its own standby archive logs automatically.

A physical standby database instance writes online redo logs.

NO.34 Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration -Animals
Protection Mode: MaxPerformance
Databases:
dogs- Primary database
sheep- Physical standby database
cats- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection:
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
What can you conclude based on this error?

Cats is a snapshot standby database.

The redo transport mode is set to ASYNC for the standby database Sheep.

The redo transport mode is set to ASYNC for both standby databases.

The redo transport mode is set to ASYNC for the standby database Cats.

NO.35 You must manually reinstate a database using DGMGRL.
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?

The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration.

The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration.

The target database should be MOUNTED and DGMGRL should be connected to the primary database.

The target database should be MOUNTED and DGMGRL should be connected to the target database.

The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database.

NO.36 On your logical standby database, you specified these rules:

Which is true regarding the execution ofthe UNSKIP procedure?

it succeeds only if SQL apply is stopped before deleting the SQL Apply filter

it succeeds but the SQL Apply fitters are not deleted.

It deletes both the SQL Apply filters.

it returns an error because the syntax to delete a SQL Apply filter must specify the same object names
as specified when the filter was added

it succeeds only if all DML statements executed on the primary have been applied on the logical
standby

NO.37 Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard?

it checks that supplemental logging is turned on if there is a logical standby database in the configuration.

it verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.

It checks that the current data protection level is consistent with the broker’s configured data protection mode.

it modifies the database configurable parameters to match the values set for the broker configuration.

It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.

NO.38 Which three statements are true about snapshot standby databases? (Choose three.)

Tablespaces can be dropped.

Tables can be dropped.

The broker may be used to fail over to a snapshot standby database.

A logical standby database can be converted into a snapshot standby database.

Tablespaces can be created.

NO.39 Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload
2. A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
Which two are true regarding the DelayMins Database Property for the standby database?

It can only be enabled for a configuration in Maximum Performance mode.

It allows user errors on the primary to be recovered by using the physical standby database.

It enables you to bypass the default network timeout interval specified for the standby redo transport destination.

It can only be enabled for a configuration in Maximum Availability mode.

It allows logical corruptions on the primary to be recovered by using the physical standby database.

It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

NO.40 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.

NO.41 Which four statements are true regarding SQL Apply filters for a logical standby database? (Choose four.)

They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

They can be used to skip ALTER SYSTEM and ALTER DATABASE commands.

They can be used to stop SQL apply if it encounters an error.

They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).

They can only be used to skip DML statements on a table.

They can be used to skip ALTER TABLE commands on a specific tables.

They can be used to skip CREATE TABLE commands.

NO.42 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.

NO.43 Which two are prerequisites for creating a standby database using Enterprise Manager cloud control?
(Choose two.)

The primary database must have FORCE LOGGING enabled.

The primary database must be in archivelog 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.

NO.44 Which four database parameters might be affected by or influence the creation of standby databases? (Choose four.)

DB_NAME

ARCHIVE_LAG_TARGET

COMPATIBLE

DB_FILE_NAME_CONVERT

DB_UNIQUE_NAME

FAL_SERVER

STANDBY_ARCHIVE_DEST

NO.45 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.

NO.46 Which two statements are true for Data Guard environments with multi-tenant databases? (Choose two.)

Different pluggable databases within a logical standby database may have different guard statuses.

The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.

The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

A multi-tenant standby database can have fewer pluggable databases than the primary container database.

NO.47 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”
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.

NO.48 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”
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.

NO.49 Which three are always benefits of using a logical standby database?

It can be used for database rolling release upgrades.

It can be used to replicate a single pluggable database (PDB) in a multitenant container database.

It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.

It can be used for reporting workloads requiring additional indexes or materialized views or both.

It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

It can be used for testing patches without affecting the primary database.

NO.50 Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database?

FLASHBACK DATABASE must be enabled on the physical standby database.

There must be connectivity between the primary and the physical standby database.

FLASHBACK DATABASE must be enabled on the primary database.

The physical standby database must have Real-Time Apply enabled.

The logical standby database must have Real-Time Query enabled

NO.51 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.

NO.52 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 .

1Z0-066 Dumps for Pass Guaranteed – Pass 1Z0-066 Exam 2022 [Q29-Q52]

Leave a Reply Cancel reply