[Jun 14, 2024] 1z0-076 Exam Brain Dumps – Study Notes and Theory [Q17-Q33]

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

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

QUESTION 19
Which three are prerequisites for enabling Fast-Start Failover?

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

QUESTION 21
Which three statements are true……. With no Oracle Streams or Goldengate configured?

QUESTION 22
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 23
Which four statements are true regarding SQL Apply filters for a logical standby database?

QUESTION 24
Which THREE statements are true…….. open in real time query mode, which becomes a new.

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

QUESTION 26
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).

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

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

QUESTION 29
Which THREE are among the various tasks performed by the Data Guard Monitor (DMON) process?

QUESTION 30
Which THREE statements are true about snapshot standby databases?

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

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

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