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

Question #1

Which three can be done using Data Guard Broker?

A. Define logical standby database skip rules.

B. Monitoring and managing redo transport services, and log apply services.

C. Automating failover to a specified target standby database.

D. Create a new physical standby database.

E. Configuring the standby control file, server parameter file, and data files for a standby database.

F. Converting physical standby databases to snapshot standby databases.

Discussion 0

Correct Answer: C,D,F Vote an answer

Question #2

Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

A. You can set a critical threshold on the redo generation rate metric for a primary database.

B. You can monitor the redo apply rate on a snapshot standby database.

C. You can monitor the redo apply rate on a logical standby database.

D. You can check the potential data loss in the event of a disaster.

E. You can set a warning threshold on the redo generation rate metric for a physical standby database.

F. You can check if redo apply needs to be tuned.

Discussion 0

Correct Answer: A,C,D Vote an answer

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

Question #3

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

A. maintaining information about all members of the broker configuration in binary configuration files.

B. activating role-based services appropriately in the various database instances of the configuration, based on the database role

C. communicating with dkon processes in other database instances that are part of the broker configuration

D. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required

E. performing role transitions when switchover requests are made

Discussion 0

Correct Answer: A,B,E Vote an answer

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

Question #4

Which three are true about using RMAN in a Data Guard environment?

A. Backups of data files taken on a physical standby are interchangeable with a primary.

B. Backups of control files taken on a physical standby are not interchangeable with a primary.

C. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.

D. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.

E. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question #5

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 #6

Examine this query and its output:

Which two statements are true?

A. The master observer is connected to the database on which the query was executed.

B. Cats is a bystander database.

C. The master observer is currently running on ol7.example.com.

D. The master observer is not running, but should run on ol7.example.com.

E. The master observer is not connected to the database on which the query was executed.

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #7

You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands:
DGMGRL> SHOW CONFIGURATION;
Configuration - DRSolution
Protection Mode: MaxPerformance
Databases:
Close_by - Primary database
FS_inst - Far Sync
Far_away - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
What is true concerning this configuration?

A. The Close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance.

B. The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance.

C. The Far Sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled.

D. The Far Sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.

E. The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the Close_by primary database is not able to do so.

Discussion 0

Correct Answer: B Vote an answer

Question #8

A customer asks you to propose the most appropriate solution for this set of requirements:
We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
We want to generate reports from the proposed standby database at the same time that it is used for data protection.
Developers may need to test occasionally on a copy of the live database Which TWO solutions would you recommend?

A. A physical standby database with real-time apply enabled

B. A logical standby database with real-time apply enabled

C. A logical standby database with real-time query enabled

D. A snapshot standby database with synchronous redo transport

E. A physical standby database with real-time query enabled

Discussion 0

Correct Answer: C,E Vote an answer

Question #9

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 #10

Your expertise is requested for these customer requirements:
The Data Guard environment must be in maximum protection mode.
Reports must be offloaded to a physical standby database.
There must be no lag between the primary and standby databases that affect the reports produced.
The primary database must be resilient in case of a single network failure.
Which solution is correct for these requirements?

A. Two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with asynchronous transport

B. One physical standby database with Real-Time Query enabled, receiving redo from two Far Sync instances that are connected to the primary

C. One physical standby database with Real-Time Query enabled and STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

D. Two physical standby databases with Real-Time Query enabled, receiving redo from the primary with the LOG_ARCHIVE_DEST_n attributes SYNC NOAFFIRM to minimize the performance impact on the primary

E. Two standby databases, at least one of them a physical standby with Real-Time Query enabled and the STANDBY_MAX_DATA_DELAY parameter set to zero, receiving redo from the primary with synchronous transport

Discussion 0

Correct Answer: E Vote an answer

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

Download Free Oracle 1z0-076 Demo