Oracle 1Z0-048 Actual Free Exam Questions & Community Discussion

You define the ERP service using this statement:
srvctl add service -d RACDB -s ERP -r RAC01 -P PRECONNECT srvctl start service -d RACDB -s
ERP
You then use this connect string to connect to your RAC instances:
ERP =
(DESCRIPTION =(FAILOVER=ON)(LOAD_BALANCE=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=N1 VIP)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=N2VIP)(PORT=1521))
(CONNECTJDATA = (SERVICE_NAME = ERP)
(FAILOVER_MODE =
(BACKUP=ERP_PRECONNECT)(TYPE=SESSION)(METHOD=PRECONNECT))))
You successfully establish a connection to your RAC database using the above connect string.
How many connections are established, and on which instances?

Which two initialization parameters must be set to start up an ASM instance in a RAC environment? (Choose two.)

Several steps must be followed to successfully add a node to your cluster database. Assuming that a UNIX platform is used, which of the steps listed below is not correct? (Choose the incorrect step.

You are working with Oracle Support to investigate to what extent a disk subsystem corruption has affected your Oracle cluster configuration. The support engineer wants you to run the OCRCHECK command and read out the output. What is the effect of running the OCRCHECK command?

The following are the steps that you have taken so far in a two-node RAC implementation:
1) Completed the preinstallation tasks
2) Performed Oracle Clusterware installation
View the Exhibit and examine the current status of a list of resources on each node.
Your next step is to install the Oracle Database 10g software on these nodes. Which statement is
true about running Oracle Universal Installer (OUI) and installing the software in this situation?

In a RAC environment, you see a steep increase for enq:HW- contention and gc current grant wait events. What would you do to fix this issue?

Which two statements are true in any RAC environment? (Choose two.)

View the Exhibit.
You are asked to help a colleague to logically remove node NLEDUC2 from a RAC cluster
installation.
On observing the colleague's terminal, you notice the output as seen in the exhibit. Based on this,
which five additional steps would you recommend? Do not be concerned with the correct
sequence for the steps.
(Choose five.)

When do you get the first notification after you execute the following command on instance
RDBA1?
execDBMS_SERVER_ALERT.SET_THRESHOLD(-
METRICSJD => dbms_server_alert.elapsed_time_per_call,
WARNINGJDPERATOR => dbms_server_alert.operator_ge,
WARNING_VALUE => 500000',
CRITICAL_OPERATOR => dbms_server_alert.operator_ge,
CRITICAL_VALUE => 750000',
OBSERVATION_PERIOD => 15,
CONSECUTIVEJDCCURRENCES => 3,
INSTANCE_NAME => 'RDBA1',
OBJECT_TYPE => dbms_server_alert.object_type_service,
OBJECT_NAME =>'ERP");

You are implementing a three-node RAC setup in your company. You have already performed these tasks:
1) Hardware and OS configuration 2) Cluster file system installation 3) Clusterware installation You executed the following command in one of the nodes: cluvfy stage -pre dbinst -n all
What is the reason for executing this command?