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

Question #19

Which two statements are true when using non-rolling release upgrades in a Data Guard environment?

A. Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a physical standby database.

B. User equivalence must be established for the owner of the Oracle software on the affected hosts prior to the upgrade.

C. During the upgrade of a logical standby database, standby redo log files must reside on O/S file systems.

D. Modifications to the data dictionary on the primary database caused by the upgrade, are applied on a logical standby database.

E. The compatible parameter on a standby database that is applying redo, must be equal to or greater than the compatible parameter on the primary that is shipping redo to that standby.

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #20

Which two are true concerning the configuring of Flashback database in a Data Guard environment?

A. It permits a primary database that was disabled after failover to be reinstated as a standby.

B. It is a prerequisite for the use of Fast Start Failover.

C. It enables the use of far sync instances.

D. It is required in order for a snapshot standby database to be converted to a physical standby database.

E. It permits a physical standby database to be converted to a snapshot standby database.

Discussion 0

Correct Answer: A,E Vote an answer

Question #21

Which three are true about using Flashback database through role transitions in a Data Guard environment?

A. Logical standby database roles are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.

B. Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.

C. Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.

D. Logical standby databases retain their current role when you flash back through to a point in time before the switchover occurred which caused this database to become a logical standby.

E. Flashback database may not be used to undo a physical standby database activation.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #22

You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload that meets these permanent requirements:
Data loss is not permitted.
Read-only applications should not connect to the primary database instance.
Additionally, there are these requirements, only one of which is ever done at any one time:
It should be possible to apply and test designated patches with a minimum amount of downtime.
Upgrading to a new database release should be performed with the least possible amount of downtime.
New application software releases should be tested against an exact up-to-date replica of the production database.
You propose a primary database with one physical standby database configured in Maximum Protection mode.
Which requirements do you meet?

A. Only requirement 1

B. 2, 3, 4, and 5

C. 1, 2, 3, 4, and 5

D. Only requirement 5

E. 1 and 2

Discussion 0

Correct Answer: A Vote an answer

Question #23

Which FOUR database parameters might be affected by or influence the creation of standby databases?

A. STANDBY_ARCHIVE_DEST

B. db_file_name_convert

C. ARCHIVE_LAG_TARGET

D. COMPATIBLE

E. FALSERVER

F. DB_NAME

Discussion 0

Correct Answer: A,B,D,F Vote an answer

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

Question #24

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

Question #25

Which TWO statements are true for Data Guard environments with multi-tenant databases?

A. Different pluggable databases within a logical standby database may have different guard statuses.

B. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

C. The Data Guard broker automatically opens all pluggable databases of a primary database after a role change operation.

D. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

E. A multi-tenant standby database can have fewer pluggable databases than the primary container database.

Discussion 0

Correct Answer: A,E Vote an answer

Question #26

Which THREE statements are true........ open in real time query mode, which becomes a new.

A. User sessions can be retained.

B. Sessions that have long running queries can be retained.

C. Sessions that are using database links

D. All current buffers can be retained.

E. All sessions are disconnected and all

F. User sessions and Current Buffers are maintained by default.

Discussion 0

Correct Answer: A,D,E Vote an answer

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

Question #27

Which two statements are true regarding Data Guard environments in an Oracle Muti-tenant architecture?

A. The Data Guard broker may be used for multi-tenant databases.

B. PDB_FILE_NAME CONVERT must be set to enable creation of standby databases if they are created on the same host as the primary.

C. Different redo transport methods can be configured for different pluggable databases within one Data Guard environment.

D. A Data Guard environment with a multi-tenant primary database can operate in any Protection mode.

E. Standby redo log files are required for each pluggable database that is protected with Data Guard.

Discussion 0

Correct Answer: A,D Vote an answer

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

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

Download Free Oracle 1z1-076 Demo