Free Oracle 1Z0-048 Exam Dumps Questions & Answers

Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to make sure that another protocol address is tried if the first one fails?

• A.  SOURCE_ROUTE
• B.  TYPE OF SERVICE
• C.  FAILOVER
• D.  LOAD_BALANCE

Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize the access to available listeners?

• A.  SOURCE_ROUTE
• B.  TYPE OF SERVICE
• C.  FAILOVER
• D.  LOAD_BALANCE

Your storage administrator informs you about some disk corruption issues in the disk subsystem where your Oracle Cluster Registry (OCR) backups are located. Your storage administrator has resolved these corruption issues by applying a patch to the storage subsystem, but to be sure that the OCR backups are not affected by this problem the administrator wants you to check the integrity of the OCR backups. How would you do this?

• A.  You can check whether the OCR backups are not corrupted by using the OCRCHECK command.
• B.  You dump the OCR backup contents into a text file by using the OCRDUMP command, and if that succeeds without errors you know that your OCR backups are not corrupted.
• C.  You create a logical export from the OCR backups by using the OCRCONFIG command and analyze the export file for errors.
• D.  You create another physical backup of the OCR backups by using the OCRCONFIG command, and if this succeeds without errors you know that the OCR backups are not corrupted.
• E.  There is no easy way to check your OCR backups for corruptions.

Over a six-month period, you have been regularly monitoring your four-instance RAC database,
which is running on the first 4 nodes of a 6-node cluster, by using ADDM and by monitoring well-
known combinations of wait event and statistics in AWR reports.
Two weeks ago, a newer version of your main application went live. Starting last week, you
noticed a large increase in CPU time (consumed by the three application services on your RAC
database) due to increased workload.
The OLTP and DSS services have not had a decrease in the percentage of time spent using CPU.
However, for the BATCH service the percentage of time spent using CPU has gone down and the
wait-time percentage has increased.
You want to recommend a tuning exercise to your team. Which two recommendations would you
make first, based on the symptoms described? (Choose two.)

• A.  The BATCH service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both.
• B.  Tune SQL for the OLTP and DSS service programs because they may benefit from SQL tuning.
• C.  The OLTP and DSS service programs may scale well and could benefit from adding new database instances on one or both of nodes 5 and 6, and by adding more nodes the SQL for BATCH service programs would perform better due to more CPU power.
• D.  The OLTP and DSS service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both.
• E.  Tune SQL from the BATCH service programs because they may benefit from SQL tuning.

Which statement regarding Clusterware is false? (Choose the false statement.)

• A.  The installation of Oracle Clusterware is mandatory even if you have installed vendor-specific clusterware.
• B.  Oracle Clusterware is installed using the Oracle Universal Installer (OUI).
• C.  The ORA_CRS_HOME directory must not be the same as the ORACLEJHOME directory.
• D.  The Oracle Database 10g Clusterware stack is compatible with Oracle 9i Group Services (GSD) processes.