Free Oracle 1z1-076 Practice Test & Real Exam Questions, Page 5

Question #37

Which two factors can cause an increase in redo transport lag?

A. The size of the online redo log files on the primary database.

B. Increase in network latency between the primary database and a redo transport destination.

C. Increase in redo generation rate on the primary database.

D. The size of the standby redo log files on the primary database.

E. The size of the online redo log files on the standby database.

Discussion 0

Correct Answer: B,C Vote an answer

Question #38

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?

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

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

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

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

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

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

Discussion 0

Correct Answer: C,D,E Vote an answer

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

Question #39

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution?

A. Ensure that flashback is enabled on the primary database.

B. Ensure that no BFILE LOB data types are contained in the primary database.

C. Do not perform any nologging operations on the primary.

D. Ensure that supplemental logging is enabled on the primary database.

E. Ensure that no ROWID data types are contained in the primary database.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #40

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:

A.

B.

C.

D.

Discussion 0

Correct Answer: D Vote an answer

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

Question #41

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

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

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

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

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

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

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #42

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

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

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

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

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

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

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #43

You have a Data Guard broker configuration consisting of:
A primary database
One local physical standby database
One far sync instance
A remote physical standby database
The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.
What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

A. Discover the primary database as a target in Enterprise Manager Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored.

B. Use the DGMGRL utility to register the configuration with the Enterprise Manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored.

C. Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.

D. Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard broker configuration will be discovered as targets automatically and be ready to be monitored.

E. Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.

Discussion 0

Correct Answer: A Vote an answer

Question #44

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
cats - Snapshot standby database
sheep - Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available
ORA-16625: cannot reach database "dogs"
DGM-17017: unable to determine configuration status
ou wish to perform a failover to sheep. Which command, or sequence of commands, should you issue to the broker before executing failover to sheep; using the broker?

A. DGMGRL> convert database sheep to physical standby;

B. None, because you can directly failover to a Snapshot Standby Database.

C. DGMGRL> convert database sheep to physical standby;
DGMGRL> edit configuration set protection mode as maxperformance;
DGMGRL> convert database sheep to physical standby;

D. DGMGRL> convert database cats to physical standby;

E. DGMGRL> convert database cats to physical standby;

Discussion 0

Correct Answer: A Vote an answer

Question #45

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
sheep - Snapshot standby database
cats - Physical 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.
Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?

A. DGMGRL> edit database sheep set property LogXptMode=sync;

B. DGMGRL> edit database dogs set property LogxptMode=sync;
DGMGRL> edit database sheep set property LogxptMode=sync;

C. DGMGRL> edit database dogs set property LogXptMode=sync;
DGMGRL> edit database cats set property LogXptMode=sync;

D. DGMGRL> edit database dogs set property LogXptMode=sync;
DGMGRL> edit database sheep set property LogxptMode=sync;
DGMGRL> edit database cats set property LogXptMode=sync;

E. DGMGRL> edit database dogs set property LogxptMode=sync;

F. DGMGRL> edit database cats set property LogXptMode=sync;

Discussion 0

Correct Answer: C Vote an answer

Free Oracle 1z1-076 Practice Test & Real Exam Questions

Download Free Oracle 1z1-076 Demo