Free Jun-2024 1z1-076 Dumps are Available for Instant Access [Q38-Q55]

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

Q39. Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?

converting the designated physical standby database into a logical standby database

creating a guaranteed restore point on the standby databases

building a LogMiner dictionary on the primary database instance

creating a guaranteed restore point on the primary database

starting media recovery on all the Leading Group Standby databases

switching the primary database to the logical standby role

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

Q41. Which two statements are true regarding asynchronous redo transport in a Data Guard

This transport mode satisfies the minimum requirements for Maximum Availability data protection mode.

A transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.

This transport mode satisfies the minimum requirements for Maximum Performance data protection mode.

Real-time query performance on a physical standby database improves for current read requests when using this transport mode.

The performance of SQL apply on a logical standby database always improves when using this transport mode.

Q42. There are currently 6 applief. and 6 pfepafef processes running and no idle applier processes on y logical standby database.
The max_SERVERS SQL apply parameter and number of archiver processes are both set to 12.
Identify two changes, each of which would allow you to increase the number of applier processes.

Decrease the number of archiver processes on the standby database.

Increase the processes initialization parameter. D Decrease the number of FREPARER processes.

Increase the value for the MAX_SERVERS SQL apply parameter.

Increase the parallel_max_server initialization parameter.

Increase the RECOVERY_PARALLEL initialization parameter.

Q43. Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?

If the primary database is not a container database, then a standby may be a container database.

If the primary database is a container database, then a physical standby may be a non-container database.

If the primary database is a container database, then a logical standby may be a non-container database.

All broker actions execute at the root container for container databases.

After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.

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

Q45. Your Data Guard environment contains a four-instance RAC primary database whose SID is PROD and a RAC physical standby database whose std is PROD_SBY.
Examine the command executed on a node of the primary database cluster to create a service OLTPWORKLOAD that the applications will use to connect to the database when it is in the FRlMARYTclatabase role:
srvctl add service -db PROD -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150 The service is then started Consider this list of tasks:
1. On a node of the standby database cluster execute:
srvctl add service -db PROD_SBY -service oltpworkload -role PRIMARY -failovertype SESSION
-failovermethod BASIC -failoverdelay 10 -failoverretry 150
2. On the primary database, create the oltpworkload database service using the dbms_service.create_service procedure.
3. Configure tap for clients in the tnsnames.ora files.
4. Make sure clients use the OLTPWORKLOAD service to connect to the database instances.
5. On the standby database, create the oltpworkload database service using the dbms_service.create_servi;l procedure.
Identify the required steps to configure and use Transparent Application Failover (taf).

4

2,3,4

5

1.4

3,4

1,3,4

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

Q47. You detected an unrecoverable archive gap in your data guard environment. So, you need to roll standby.
forward in time without applying a large number of archive log files using this command:
RMAN> RECOVER STANDBY DATABASE FROM SERVICE-<primary database name>;
When running this command, which of the following steps can be performed automatically?
1. Remember all data file names on the standby.
2. Restart standby in nomount.
3. Restore controlfile from primary.
4. Mount standby database.
5. Rename data files from stored standby names.
6. Restore new data files to new names.
7. Recover standby.

2,3,5,6,7

2,3,6,7

1,3,5,6,7

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

1, 2,3,4,6,7

Q48. Your Data Guard configuration consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled
4. Redo transport mode is synchronous
5. Protection mode is maximum availability
6. The Data Guard broker is used
You notice that the standby destination fails to acknowledge reception of redo within net_timeout period of time.
Which is true in this scenario?

Real-time query will be disabled on the physical standby.

The protection mode will automatically change to Maximum Performance.

Synchronous redo transport mode connections to the standby database are terminated.

The physical standby database instance is shut down by the Data Guard broker.

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

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

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

Q52. Which TWO are TRUE about offloading backups to a physical standby database in a Data Guard environment?

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

The standby database can not 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.

Q53. Which TWO are benefits of using Transaction Guard in a Data Guard environment?

It protects against user errors being replicated to standby databases.

It provides application continuity by rolling back uncommitted transactions interrupted by a failover or switchover.

It protects against logical corruptions being replicated to standby databases.

It protects against recoverable errors during a planned or an unplanned outage of a primary database.

It provides application continuity by replaying transactions interrupted by a failover or a switchover

Q54. Your Data Guard environment has one physical standby database using Real-Time Query. Two sequences have been created by these SQL statements:

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. Which output will be seen for session 2?
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?