1z1-076 by Oracle Actual Free Exam Q&As

Question 1

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. 2, 3, 4, and 5 B. Only requirement 1 C. Only requirement 5 D. 1, 2, 3, 4, and 5 E. 1 and 2

Discussion 0

Correct Answer: B Vote an answer

Question 2

Which THREE statements are true about snapshot standby databases?

A. Snapshot standby databases may be used for rolling database upgrades. B. If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database. C. A snapshot standby database must be opened at least once in read-write mode before it can be converted into a physical standby database. D. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database. E. A snapshot standby database can be the only standby database in a Maximum Protection Oracle Data Guard configuration.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 3

Which TWO statements are true regarding Data Guard Broker?

A. It can be used to create and manage standby databases. B. It can be used to monitor redo transport and log apply services. C. It can be used to perform failovers and switchovers. D. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration. E. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.

Discussion 0

Correct Answer: A,C Vote an answer

Question 4

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

A. To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host. B. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host. C. The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance. D. A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts. E. To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

Discussion 0

Correct Answer: B Vote an answer

Question 5

Which three statements are true about snapshot standby databases?

A. A resize command to extend the size of a datafile in the snapshot standby database, which was created in the primary database, will succeed. B. A resize command to extend the size of a datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed. C. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the physical standby database, will succeed. D. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the snapshot standby database, will succeed. E. A resize command to reduce the size of an empty datafile in the snapshot standby database, which was created in the primary database, will succeed.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 6

Examine this query and its output:

Which two statements are true?

A. The master observer is not connected to the database on which the query was executed. B. The master observer is currently running on ol7.example.com. C. Cats is a bystander database. D. The master observer is connected to the database on which the query was executed. E. The master observer is not running, but should run on ol7.example.com.

Discussion 0

Correct Answer: A,C Vote an answer

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

Oracle Database 19c: Data Guard Administration - 1z1-076 Exam Practice Test