Instantly download 1Z0-048 updated real questions

Oracle 1Z0-048 Exam Overview:

Oracle 1Z0-048 Exam Syllabus Topics:

Oracle Database 10g R2: Administering RAC Sample Questions:

1. View the Exhibit, which displays the cluster database performance page after the same workload has been executed three times on your cluster without varying any non-Oracle workloads on the cluster. What are the two ways by which you can tell that the corresponding application was better tuned during the second and third execution? (Choose two.)

A) It takes less time to execute the workload each time.
B) The run queue length is going down each time.
C) The number of transactions per second is getting higher each time.
D) There is less paging each time
E) The database throughout graphic is below the red dashed line during the last execution.

2. You are about to bring your Web server under control of the Oracle Clusterware to make it highly available. Which actions do you need to perform to accomplish this task? (Choose all that apply.

A) Once done, manage the Web server with SRVCTL
B) Have the system administrator create an application VIP at the operating system level for you to use with the application.
C) Create an application VIP profile using crs_profile, register it with crs_register, set its permission with crs_setperm, and then start it using crs_start.
D) Write an action script that Oracle Clusterware would use to start, stop, and check the status of an application.
E) Create an application profile using crs_profile, register it with crs_register, set its permission with crs_setperm, and then start it with crs_start.

3. Which three statements regarding backup of the voting disk are true? (Choose three.)

A) A backup of the voting disk should be taken whenever an existing node is removed from the cluster.
B) A backup of the voting disk should be taken whenever an RMAN catalog reset is done.
C) Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in the cluster.
D) On UNIX platforms, the voting disk can be backed up with the dd command.
E) A backup of the voting disk should be taken whenever a new node is added to the cluster.

4. 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.)

A) Set fast_start_mttr_target to a higher value.
B) Increase the sequence cache size if retaining the sequence.
C) Set _lm_msg_batch_size to a higher value.
D) Re-create the index as a global hash partitioned index.
E) Re-create the table using a natural key instead of a surrogate key.
F) Encourage shorter transactions.

5. Which three statements about patching Oracle products in a clustered environment are true? (Choose three.)

A) OUI manages patches in a clustered environment only if a shared ORACLEJHOME is employed.
B) OUI prevents potentially destructive concurrent patch installations through the use of Inventory List Locks.
C) The OUI automatically manages the patch installation progress, including the copying of files to remote nodes, just as it does with the CRS and database binary installations.
D) The Oracle Universal Installer (OUI) is cluster-aware and able to manage patches on all nodes in your cluster.

Solutions: