Free 1z1-076 Questions for Oracle 1z1-076 Exam

Question #1

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

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

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

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

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

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

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #2

Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled.
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors: ORA-03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

A. Change the protection mode to Maximum Performance.

B. Reduce I/O latency for the storage used by the primary database.

C. Increase the network bandwidth between the primary and standby databases.

D. Change the protection mode to Maximum Protection.

E. Increase the number of standby redo log files on the primary database.

F. Increase the size of the buffer cache on the standby database instance.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #3

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.

A. 2,3,6,7

B. 2,3,5,6,7

C. 1,3,5,6,7

D. 1, 2,3,4,6,7

E. 1,2,3,4,5,6,7

Discussion 0

Correct Answer: D Vote an answer

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

Question #4

Your Data Guard environment contains a primary database and three standby databases with these attributes:
1. prod : Primary database
2. prod_prq : Physical standby database with real-time query enabled used by reporting applications
3. prod_lsby: Logical standby database used by DSS
4. PROD_SSBY: Snapshot standby database used for Real Application Testing Which TWO can be used to prevent clients from connecting to the wrong database instance?

A. Establish Oracle Net connectivity to the primary database instance from all the standby database instances.

B. Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.

C. Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.

D. Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.

E. Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #5

You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:

Which three statements are true regarding the execution of the command?

A. The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.

B. The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance.

C. The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.

D. The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.

E. The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.

F. The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.

Discussion 0

Correct Answer: B,E,F Vote an answer

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

Question #6

Which TWO statements correctly describe the behavior of Automatic Block Media Recovery in a Data Guard environment, for a corrupt block in the example tablespace encountered by a session logged in as the SH user?

A. A corrupt block on a standby database with Real-Time Query enabled, is automatically recovered, using flashback logs from the standby database.

B. A corrupt block on the primary database is automatically recovered, using a block from a flashback log from the primary database.

C. A corrupt block on a standby database with Real-Time Query enabled, can be automatically recovered, using a block from the primary database.

D. A corrupt block on the primary database can be automatically recovered, using a block from a standby database with Real-Time Query enabled.

E. A corrupt block on the primary database is automatically recovered, using a block from a flashback log from a standby database with Real-Time Query enabled.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #7

Which THREE are true about using flashback database in a Data Guard environment?

A. You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption.

B. It may not be used to flash back a primary database after a failover to a physical standby.

C. It may be used to flash back a physical standby that receives redo from a far sync instance.

D. When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically.

E. You can use it when real-time apply is enabled in case the phylt may not be used to flash back a primary database after a failover to a logical standby.

F. When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically.

Discussion 0

Correct Answer: A,B,C Vote an answer

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

Question #8

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 logical standby database while SQL apply is active.

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

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

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

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

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

Discussion 0

Correct Answer: A,D,E Vote an answer

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

Free 1z1-076 Questions for Oracle Database 19c: Data Guard Administration 1z1-076 Exam as PDF & Practice Test Engine

Download Free Oracle 1z1-076 Demo