[Jan 15, 2023] Pass Your 1Z0-066 Dumps Free Latest Oracle Practice Tests [Q63-Q78]

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

Support for workloads requiring additional indexes.

It can be used to create additional schemas.

It can be used to create additional tables.

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

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

Support for workloads requiring additional materialized views.

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

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

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

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.

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.

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.

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.

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.

NEW QUESTION 66
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 67
Which three are true concerning restoring of RMAN backups to primary and physical standby databases
in a Data Guard environment?

Backups of data files taken on the primary database may be restored on a physical standby database.

Backups of control files taken on the primary database may not be restored and used on a physical
standby database.

Backups of SPFILEs taken on a physical standby database may not be restored on the primary
database.

Backups of control files taken on a physical standby database may be restored on the primary
database.

Backups of data files taken on a physical standby database may be restored on a pnmary database.

Backups of SPFILEs taken on the primary database may not be restored and used on a physical
standby database.

NEW QUESTION 68
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_l 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.

NEW QUESTION 69
Which two are true about database roles in an Oracle Data Guard Configuration? (Choose two.)

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.

NEW QUESTION 70
A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows.
As a result of this, you decide that an upgrade may use logical standby databases.
Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary? (Choose two.)

The upgrade always requires downtown until the upgrade of the logical standby is completed.

Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.

The upgrade always required downtime until the upgrade of the primary is completed.

Using manual upgrade, catupgr.sql needs to run on the primary database only.

SQL Apply on the local 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.

NEW QUESTION 71
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

NEW QUESTION 72
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 73
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 74
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.

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

NEW QUESTION 76
You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN.
Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?
(Choose two.)

The standby database must have supplemental logging enabled.

The primary database must have FORCE LOGGING enabled.

The DG_BROKER_START parameter must be set to TRUE for both database instances.

The primary database must have supplemental logging enabled.

A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.

NEW QUESTION 77
Examine the Fast-start configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: sheep
Observer : ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
Which three are true? (Choose three.)

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.

NEW QUESTION 78
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.)