Which three steps must be completed to configure Fast Connection Failover for the CRM service with an Oracle Call Interface client? A. Ensure that the CRM service has Advanced Queuing notifications enabled by setting the services values of AQ_HA_NOTIFICATIONS to…

The DBA has executed the command: srvctl add service -d PROD -s BATCH -g SP2 -c singleton -y manual What is the result of this command? A. Creates a singleton service named BATCH using the server pool SP2 with a…

Assuming a RAC database called ORCL, select three statements that correctly demonstrate management actions for the AP service. A. To start the AP service, execute: srvctl start service -d ORCL -s AP B. To disable the AP service on the…

Which two actions in a warehousing RAC database may cause concurrent cross-instance calls leading to I/O contention? A. truncate table statements B. select statements referring to non-partitioned tables C. drop table statements D. insert statements where each instance inserts into…

You are managing a policy-managed database called RACDB. Examine the output given below: $ echo $ORACLE_SID RACDB_1 $ sqlplus / as sysdba SQL> SELECT * FROM V$ACTIVE INSTANCES; You used these commands to add the service ERP: $ srvctl add…

Which two statements are true regarding the Automatic Workload Repository (AWR) in a RAC environment? A. The AWR includes time model statistics based on time usage for activities displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views. B. The AWR is controlled…

Examine the following details for a six-instance RAC database: What is the most prominent problem indicated by the above output? A. high input/output (I/O) delays B. CPU saturation and memory depletion C. large number of untuned queries from one of…

In your two-instance RAC database, you find that FAST_START_MTTR_TARGET is set to 300 on both the nodes. The ESTD_CLUSTER_AVAILABLE_TIME column in the V$INSTANCE_RECOVERY view shows the value 100. What is the correct interpretation? A. In the event of an instance…

You are managing a single-Instance database and your company wants to convert the single-Instance database to an Oracle RAC database. You plan to use the rconfig utility to accomplish this task. What are the prerequisites for converting the single-instance database…

Which four statements are true about services and connection load balancing? A. Services provide the ability to balance client connections across the instances in an Oracle RAC configuration. B. There are two types of load balancing that you can implement;…