Latest Oracle 1z1-076 Actual Free Exam Questions & Community Discussion, Page 1

Question #1

Which three are true concerning database states after a successful switchover?

A. If the former primary database became a logical standby database it will be in mount state.

B. If the former primary database became a physical standby database it will be in the same state as the former physical standby database.

C. If the former primary database became a logical standby database it will be open read-write.

D. The new primary database will be open read-write.

E. If the former primary database became a physical standby database it will always be open readonly.

F. The former primary database will always be open.

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question #2

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

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

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

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

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

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

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #3

Which THREE steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

A. startup nomount the standby database instance.

B. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME name parameter.

C. Configure Oracle Net connectivity on the primary host to the standby database instance.

D. Establish user equivalence for the database software owner between the primary host and standby host.

E. Put the primary database into archivelog mode.

Discussion 0

Correct Answer: A,C,D Vote an answer

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

Question #4

Which three statements are true about snapshot standby databases?

A. Tables can be dropped.

B. Tablespaces can be created.

C. The FATLOVER TO command results in a transition of a snapshot standby database to the primary role.

D. The switchover TO command allows a switchover operation to a snapshot standby database.

E. A logical standby database can be converted into a snapshot standby database.

F. Tablespaces can be dropped.

Discussion 0

Correct Answer: A,B,F Vote an answer

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

Question #5

Examine the fast-start failover configuration:

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

B. The observer is running.

C. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.

D. You must disable fast-start failover first to change the fast-start failover target to East sales.

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

Discussion 0

Correct Answer: A,B,C Vote an answer

Question #6

A Data Guard environment has this configuration and these attributes:
A primary database
A physical standby database named sbdb
The configuration is in maximum availability protection mode.
Then sbdb is converted to a snapshot standby database.
Which two statements are true?

A. The recovery point objective increases.

B. The protection mode is lowered to maximum performance.

C. The recovery time objective increases.

D. sbdb can still apply redo.

E. sbdb can still receive redo.

Discussion 0

Correct Answer: A,E Vote an answer

Question #7

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

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

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

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

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

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

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #8

You are using Data Guard in conjunction with Global Database Services.
You have a Data Guard Broker configuration called Sales and a GDS pool called Prod.
Which three are true concerning the management of the broker configuration when using GDS?

A. Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services.

B. DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool.

C. Adding a database to the Sales configuration with DGMGRL automatically adds the database to the Prod Pool.

D. Adding a database to the Sales configuration with DGMGRL requires that the Sales configuration be disabled first. It must then be enabled after the new database is added to the configuration.

E. DGMGRL may be used to add the Sales configuration to the Prod pool in gds.

Discussion 0

Correct Answer: A,B,E Vote an answer

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

Question #9

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

A. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

B. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

C. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

D. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

E. Primary and physical standby databases may use different virtual recovery catalogs in the same physical recovery catalog.

Discussion 0

Correct Answer: D,E Vote an answer

Question #10

The Oracle database 19c Observer is currently running on host1 and you wish to have it running on host2.
Examine this list of possible steps:
1) Stop the observer on host1
2) Disable Fast-Start Failover
3) Update the broker configuration with the new observer hostname
4) Enable Fast-Start Failover
5) Start the Observer on host2
Which contains the minimum required steps to move the observer to host2?

A. Execute tasks 1, 2, 3, 4, and 5

B. Execute tasks 1, 3, and 5

C. Execute only task 5

D. Execute tasks 1 and 5

Discussion 0

Correct Answer: B Vote an answer

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

Oracle 1z1-076 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z1-076 Demo