2024 Realistic 1z0-076 Dumps Latest Oracle Practice Tests Dumps [Q19-Q37]

NEW QUESTION 19
Which THREE are always benefits of using a logical standby database?

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 reporting workloads requiring additional indexes or materialized views or both.

It can be used for testing patchsets without affecting the primary 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.

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

the number of PREPAER processes

the number of coordinator processes on the standby database instance

the number of full table scans performed by SQL apply

the size of the undo tablespace on the logical standby database

the number of applier processes

the size of the shared pool

NEW QUESTION 21
You must configure an Oracle Data……….
1. A primary database
2. A physical standby database
Examine these requirements: 1. Data loss is not permitted.
1. Data loss is not permitted.
2. It should be possible to convert the physical standby database to a snapshot standby database.
3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it has been received by the standby database instance.
4. The availability of the primary database should not be compromised by the availability of the standby database.
5. It should be possible to convert the physical standby database to a logical standby database
6. It should be possible to deploy Real Application Clusters on the primary database.
7. It should be possible to deploy Real Application Clusters on the physical standby database.
You configure SYNC redo transport mode in combination with Maximum Protection mode.

1, 2, 3, 6, and 7

1, 2, 3, 4, 5, 6, and 7

1, 2, 6, and 7

1, 6, and 7

1, 2, and 5

NEW QUESTION 22
Which three types of backups offload …….. with the primary database in a data Guard

Control files

Broker configuration files

Password files

Data files

Online logs

Archive logs

NEW QUESTION 23
Examine this validate command:
DGMGRL> VALIDATE DATABASE VERBOSE “<database name>”;
Which THREE statements are TRUE?

The command performs a comprehensive set of database checks prior to a role change.

The command performs a comparison of SPFILE entries between the primary database and a specified standby database.

The command performs network connectivity checks between members of a broker configuration.

The command can be used for a logical standby database.

The command uses information available in various Oracle Data Guard views as well as the Automatic Diagnostic Repository.

NEW QUESTION 24
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 set of actions will fulfill this requirement?

Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

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.

Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

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.

NEW QUESTION 25
Which THREE statements are true about Far Sync instances?

They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.

They use an spfMe, a standby controlfile, and standby redo logs.

They work with any protection level.

A primary database can ship redo directly to multiple Far Sync instances.

The Data Guard Broker must be used to deploy and manage Far Sync instances.

NEW QUESTION 26
Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

You can monitor the redo apply rate on a logical standby database.

You can set a critical threshold on the redo generation rate metric for a primary database.

You can set a warning threshold on the redo generation rate metric for a physical standby database.

You can check if redo apply needs to be tuned.

You can check the potential data loss in the event of a disaster.

You can monitor the redo apply rate on a snapshot standby database.

NEW QUESTION 27
Which four requirements can be met by deploying a logical standby database?

Support for workloads requiring additional materialized views.

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

It can be used to create additional tables.

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

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

Support for workloads requiring additional indexes.

It can be used to create additional schemas.

NEW QUESTION 28
Which three statements are true about snapshot standby databases?

The FATLOVER TO command results in a transition of a snapshot standby database to the primary role.

Tablespaces can be dropped.

Tablespaces can be created.

The switchover TO command allows a switchover operation to a snapshot standby database.

Tables can be dropped.

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

NEW QUESTION 29
Which THREE statements are true about Far Sync instances?

The Data Guard Broker must be used to deploy and manage Far Sync instances.

They work with any protection level.

They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.

They use an spfMe, a standby controlfile, and standby redo logs.

A primary database can ship redo directly to multiple Far Sync instances.

NEW QUESTION 30
You notice that the SQL apply lag on your logical standby database has increased but the redo transport lag has not.
Which four could be reasons for the increase in SQL apply lag?

An undersized undo tablespace on the logical standby

Many SQL apply operations do full table scans

An increased number of bulk updates on the primary

An increased number of bulk inserts on the primary

The standby redo log files are undersized on the primary database

An undersized shared pool

NEW QUESTION 31
A customer asks for your recommendation regarding this requirement:
1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.
2. We want zero data loss in case of a disaster involving the loss of one component.
3. We want to do Real Application Testing occasionally on the Standby Database.
Which solution, if any, satisfies these requirements?

These requirements cannot be met.

A physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing

A snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing

A far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing

NEW QUESTION 32
You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN.
You are planning to create a Data Guard Broker configuration. You execute the command:

Which three statements are true regarding the execution of the command?

The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance.

The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.

The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.

The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.

The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.

The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.

NEW QUESTION 33
You must configure flashback database for your Oracle 19c databases that will be part of a Data Guard Broker configuration.
The databases are all in ARCHIVELOG mode.
You will execute the SQL statement:
ALTER DATABASE FLASHBACK ON;
Which three are true concerning this command?

It will execute successfully while an Oracle 19c primary database is open.

It will execute successfully while an Oracle 19c primary database is mounted.

It will execute successfully on an Oracle 19c physical standby database while Real Time Query is active.

If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all logical standby databases that are part of the configuration.

It will execute successfully on an Oracle 19c logical standby database while SQL apply is active.

If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all physical standby databases that are part of the configuration.

NEW QUESTION 34
On your logical standby database, you specified these rules:

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

Which is TRUE regarding the execution of the UNSKIP procedure?

It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

It deletes both the SQL Apply filters.

It succeeds but the SQL Apply filters are not deleted.

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

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.

NEW QUESTION 35
Your Data Guard environment consists of these components and settings:
1. A primary database
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.
You notice that queries executed on the physical standby database receive errors: ORA-03172:
STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

Increase the size of the buffer cache on the standby database instance.

Reduce I/O latency for the storage used by the primary database.

Increase the number of standby redo log files on the primary database.

Change the protection mode to Maximum Performance.

Increase the network bandwidth between the primary and standby databases.

Change the protection mode to Maximum Protection.

NEW QUESTION 36
Examine the Data Guard configuration:

What happens if you issue “switchover to sheep;” at the DGMGRL prompt?

The switchover succeeds and Cats becomes the new failover target.

It results in an error indicating that a switchover is not allowed.

The switchover succeeds but Dogs needs to be reinstated.

The switchover succeeds and Fast-Start Failover is suspended.

The switchover succeeds and Dogs becomes the new failover target.

NEW QUESTION 37
You created two remote physical standby databases using SQL and RMAN.
The primary database is a four-instance RAC database and each physical standby database has two instances.
Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.
Consider these operational requirements:
* The ability to manage multiple standby databases with a single tool
* The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases
* The automation of failovers to a specified target standby database
Which TWO tools can be used to fulfill these requirements7

RMAN

SQL*Plus

CRSCTL

Enterprise Manager Cloud Control

DGMGRL

SRVCTL

GDCCTL