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

Which initialization parameter would you use for each RAC instance to make sure that each listener on each RAC node is aware of the load of all the others?

After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk. Which are the two ways in which you can accomplish this task? (Choose two.)

To install Oracle Database 10g RAC on a UNIX platform, which four directories will you identify for use? (Choose four.)

What does server-side Connect-Time Load Balancing do to complement the client-side Connect-Time Load Balancing function of balancing the connection requests to all the listeners in the address list on the client side?

You have a four-node cluster with instances RDBD1, RDBD2, RDBD3, and RDBD4. While evaluating statspack reports, you find nq: TX- index contention on page one under the category op 5 Timed Events.
Further study finds an unusually high number of c buffer busy waits in the Wait Events section.
Checking the Instance Activity Stats section, you see an unusually high value for eaf Node Splits.
Using v$segment_statistics, you identify that the top segment with c buffer busy waits is the index products_pk, which obtains the primary key from a sequence. You wish to present alternative solutions to the team to help reduce contention.
Which three actions would you recommend to reduce the overheads? (Choose three.)

Your four-node RAC cluster is no longer coping with workloads for one of its databases at peak periods and you decide to add another node to the cluster. The current configuration has two RAC databases, each with four instances with only the second database using ASM as a clustered database file system. ASM is installed in a separate home. Which five steps must you take to add all the software components and processes to the new node before you run DBCAto add database and ASM instances on the new cluster nodes. Do not be concerned with the correct sequence for the steps. (Choose five.)

After a power failure, you noticed that one of your cluster database instances did not start automatically, whereas all other instances came up successfully. What would you do to determine the precise cause for the instance startup failure? (Choose three.)

You are about to build a new Oracle Clusterware-based cluster and you want to make the installation process as smooth as possible. You decide to use the Cluster Verification Utility (CLUVFY) to check whether or not your system administrator has set up the hardware and system software correctly. Which two statements about CLUVFY are true? (Choose two.)

You are creating a database in your RAC implementation. You are using the DBCA to create the database, and you selected the Raw Devices Mapping file on one of the screens of the DBCA. What is the reason for selecting this file?

Your company requires that certain database systems be made continuously available because there are revenue-earning applications using Oracle databases. You already use RAC; it is a requirement for the applications to have continuous read and write access to all schema objects in the database during routine DBA maintenance activities. Which three technologies would you recommend for minimizing planned downtime for the application caused by unavailability of data due to those activities? (Choose three.)