[Jun-2024] Free 1z1-076 Exam Dumps to Improve Exam Score [Q15-Q37]

QUESTION 15
The Oracle database 19c 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?

Execute tasks 1 and 5

Execute only task 5

Execute tasks 1, 3, and 5

Execute tasks 1, 2, 3, 4, and 5

QUESTION 16
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.

QUESTION 17
Examine the following parameter settings of the physical standby database:
* STANDBY_FILE_MANAGEMENT=AUTO
* ENABLED_PDBS_ON_STANDBY=<null>
During which TWO tasks are files automatically created in the physical standby database after structure changes on the primary database?

Performing transportable tablespaces

Adding or dropping a redo file group

Adding a data file or creating a tablespace

Creating a PDB from the existing PDB within the same CDB

Renaming a data file in the primary database

QUESTION 18
Which two statements are true regarding Data Guard environments in an Oracle Muti-tenant architecture?

Different redo transport methods can be configured for different pluggable databases within one Data Guard environment.

The Data Guard broker may be used for multi-tenant databases.

PDB_FILE_NAME CONVERT must be set to enable creation of standby databases if they are created on the same host as the primary.

Standby redo log files are required for each pluggable database that is protected with Data Guard.

A Data Guard environment with a multi-tenant primary database can operate in any Protection mode.

QUESTION 19
You are planning to perform block comparison using the dbms comp package:

Which TWO statements are true?

The databases should be at least mounted before block comparison.

Logical standby databases can be the target database for the dbms_dbcomp.dbcomp procedure.

It requires that the DB_LOST_WKITE_protect initialization parameter be enabled.

You can monitor the progress of an ongoing block comparison operation by querying VS SES SION_LONGOPS.

It can be used to detect lost writes and inconsistencies between the primary database and the cascaded standbys.

QUESTION 20
Which THREE statements are TRUE about the supported workload in Active Data Guard standby databases?

PL/SQL blocks that you run on Active Data Guard standby databases can be always redirected to and run on the primary database.

Read-mostly reporting applications that use global temporary tables for storing temporary data can be offloaded.

You might have to use sequences with global temporary tables to support read-mostly applications by using Active Data Guard.

The DDL operations on private temporary tables are transparently redirected to the primary database.

The DML operations on a standby can be transparently redirected to and run on the primary database

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

QUESTION 22
Examine the fast-start failover configuration:

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

If South_Sales develops a problem and cannot be the target of a failover, the broker automatically changes the fast-start failover target to one of the other candidate targets.

The observer will initiate a failover when the primary database is unable to produce local archived redo log files.

You must disable fast-start failover first to change the fast-start failover target to East sales.

The observer is running.

QUESTION 23
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.

QUESTION 24
In Oracle Database 19c, you can set the value of database initialization parameters in a database using the EDIT DATABASE… SET PARAMETER Command:
DGMGRL> EDIT DATABASE ‘boston’ SET PARAMETER log_archive_trace – 1;
Which THREE statements are TRUE about the command?

The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.

The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.

The database must be available when the above command is run.

The value set using this command is directly stored in the broker configuration file.

The value set using this command is directly applied to the boston database.

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

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.

startup nomount the standby database instance.

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

Put the primary database into archivelog mode.

QUESTION 26
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?

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

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

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

Cats is a snapshot standby database.

QUESTION 27
Examine this list of possible steps:
1. Raise the compatibility level on both databases.
2. Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

1,5,2,4,6,3

5,2,4,6,3,1

4,6,5,2,3,1

5,2,4,1

5,2,4,3,6,1

QUESTION 28
You must design an Oracle Data Guard configuration for a DSS database that meets these permanent requirements:
1. Creating and maintaining bitmap indexes should not impact the performance of the primary database.
2. Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest of databases?

a primary database with one logical standby database

a primary database with two logical standby databases

a primary database with one physical standby database

a primary database with two physical standby databases

A primary database with one logical and one physical standby database

QUESTION 29
You created a physical standby database prodsbyi from the primary database prod using SQL and RMAN.
Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases?

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

The primary database must have supplemental logging enabled.

The LOG_ARCHIVE_DEST_n parameters with the service attribute set must be cleared.

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.

QUESTION 30
Which TWO statements are true about configuring Oracle Net Service in a Data Guard environment?

A static service must be registered with the local listener to enable DGMGRL to restart instances during the course of broker operations.

Install the oracle-database-preinstall-19c package to set the kernel parameters for Oracle Net based on the Data Guard best practice guidelines.

Installing the oracle-database-preinstall-19c package is NOT sufficient to set up operating system kernel parameters for Oracle Net.

Enterprise Manager does not require static service registration to restart instances during the course of broker operations.

It is necessary to use the failover clause for an address_list with multiple address lists in the tnsnames.ora file.

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

QUESTION 32
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.

QUESTION 33
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

QUESTION 34
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

QUESTION 35
Which THREE statements are TRUE about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

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

Their creation requires that a LOG archive_dest_n parameter be defined in the standby that points back to the primary.

If the CACHE option is set then the size of the cache must be at least 100.

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

They must have the NOORDEK and CACHE options set.

QUESTION 36
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.

QUESTION 37
Which THREE are true about using flashback database in a Data Guard environment?

When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically.

You can use it when real-time apply is enabled in case the phylt may not be used to flash back a primary database after a failover to a logical standby.

It may be used to flash back a physical standby that receives redo from a far sync instance.

You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption.

It may not be used to flash back a primary database after a failover to a physical standby.

When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically.