1z1-076 Exam Training Practice Tests (Oracle Database 19c: Data Guard Administration)]

Question 1

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

A. It protects against recoverable errors during a planned or an unplanned outage of a primary database. B. It protects against logical corruptions being replicated to standby databases. C. It provides application continuity by replaying transactions interrupted by a failover or a switchover D. It protects against user errors being replicated to standby databases. E. It provides application continuity by rolling back uncommitted transactions interrupted by a failover or switchover.

Correct Answer: A,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

Which three statements are true about redo transport?

A. Multiple RFS processes may receive redo on one standby database instance. B. With synchronous redo transport, LGWR ships redo directly to RFS processes on the standby database instances and waits for an acknowledgment. C. Multiple RFS processes may receive redo on one far sync instance. D. An RFS process on a standby database instance may receive redo from an archiver process on the primary database instance to perform archive gap resolution. E. With asynchronous redo transport, TTnn processes may read redo from the log buffer or from standby redo logs on the primary database.

Correct Answer: A,B,D

Question 3

Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

A. Dogs will be in the disabled state and has to be manually reinstated. B. Sheep will be in the enabled state. C. The configuration will be in Maximum Availability mode. D. Sheep will be in the disabled state. E. The configuration will be in Maximum Performance mode.

Correct Answer: A,B,C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

Which THREE statements are true about Far Sync instances?

A. They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary. B. A primary database can ship redo directly to multiple Far Sync instances. C. They work with any protection level. D. The Data Guard Broker must be used to deploy and manage Far Sync instances. E. They use an spfMe, a standby controlfile, and standby redo logs.

Correct Answer: A,B,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

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

A. They are required on a physical standby for real-time apply. B. It is recommended to have them on the... C. They are required only for synchronous redo transport D. The LGWR process writes to them on .... E. Only standby databases can write redo.... F. They are required on a logical standby for real-time apply

Correct Answer: A,D,F

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

You are licensed to use Oracle Active Data Guard.
Which TWO statements are true after enabling block change tracking on a physical standby database?

A. It allows fast incremental backups to be offloaded to the physical standby database. B. It starts the CTWR process on the physical standby database instance. C. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database is converted. D. It allows fast incremental backups to be taken on the primary database. E. It starts the RVWR process on the physical standby database instance. F. It starts the CTWR process on the primary database instance.

Correct Answer: A,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

A. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts. B. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE. C. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners. D. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host. E. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.

Correct Answer: C,E

Question 8

Which three statements are true about snapshot standby databases?

A. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the physical standby database, will succeed. B. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed. C. A resize command to extend the size of a datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed. D. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the primary database, will succeed. E. A resize command to extend the size of a datafile in the snapshot standby database, which was created in the primary database, will succeed.

Correct Answer: B,C,E

Question 9

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

A. PL/SQL blocks that you run on Active Data Guard standby databases can be always redirected to and run on the primary database. B. The DML operations on a standby can be transparently redirected to and run on the primary database C. Read-mostly reporting applications that use global temporary tables for storing temporary data can be offloaded. D. The DDL operations on private temporary tables are transparently redirected to the primary database. E. You might have to use sequences with global temporary tables to support read-mostly applications by using Active Data Guard.

Correct Answer: B,C,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 10

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?

A. Cats is a snapshot standby database. B. The redo transport mode is set to asyn: for the standby database Cats. C. The redo transport mode is set to async for both standby databases. D. The redo transport mode is set to async for the standby database Sheep.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Oracle Database 19c: Data Guard Administration - 1z1-076 Exam Practice Test