Practice Oracle 1Z0-076 Exam Questions

Which two are true about database roles in an Oracle Data Guard configuration?

You must design an Oracle Data Guard configuration for a DSS database that meets these permanent requirements 1. Creating and maintaining bitmap indexes should not impact the performance of the primary database. 2. Creating and maintaining materialized views should not impact the performance of the primary database. Additionally, there are these requirements, only one of which is ever done at any one time 1. It should be possible to apply designated patches with a minimum amount of downtime. 2. Upgrading to a new database release should be performed with the least possible amount of downtime. 3. New application software releases should be tested against an exact and up - to - date replica of the primary database. Which configuration meets these requirements with the fewest of databases?

You created two remote physical standby databases using SQL and RMAN. The primary database is a four - instance RAC database and each physical standby database has two instances. Roles - based services are used for client connectivity and have been defined in the Grid Infrastructure. Consider these operational requirements • The ability to manage multiple standby databases with a single tool • The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases • The automation of failovers to a specified target standby database Which TWO tools can be used to fulfill these requirements7

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?

Examine this query and its output:



Which two statements are true?