Online Access Free 1z1-076 Practice Test

Which TWO statements are true about Real-Time Query?

• A.Real-Time Query sessions can be connected to a Far Sync instance.
• B.Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
• C.Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.
• D.Setting standby_max_data_delay=0 requires synchronous redo transport.
• E.A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

Examine the procedure that you plan to execute on your logical standby:
SQL> EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'DML', schema_name => 'HR', object_name => 'EMPLOYEE'); What is a prerequisite for execution of this procedure?

• A.Stop SQL Apply on the logical standby database.
• B.Execute the DBMS_LOGSTDBY.APPLY_SET procedure to record errors that might cause SQL Apply to stop.
• C.Change the redo transport mode if necessary to ASYNC.
• D.Stop redo transport to the logical standby database.

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 is required in order for a snapshot standby database to be converted to a physical standby database.
• D.It permits a physical standby database to be converted to a snapshot standby database.
• E.It enables the use of far sync instances.

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?

• A.a primary database with one logical standby database
• B.a primary database with two logical standby databases
• C.a primary database with one physical standby database
• D.A primary database with one logical and one physical standby database
• E.a primary database with two physical standby databases

Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN?

• A.Run the nid utility to modify the DBID of the primary database.
• B.Configure Oracle Net connectivity between the primary host and the standby host.
• C.Create a standby control file.
• D.Transfer a copy of the password file from the primary host to the standby host.
• E.Create an SPFILE for the standby database.