Study with Oracle : 1Z0-048 Exam Torrent as your best preparation materials

Oracle 1Z0-048 Exam Overview:

Oracle 1Z0-048 Exam Syllabus Topics:

Oracle Database 10g R2: Administering RAC Sample Questions:

1. 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) The Oracle Universal Installer (OUI) is cluster-aware and able to manage patches on all nodes in your cluster.
C) OUI prevents potentially destructive concurrent patch installations through the use of Inventory List Locks.
D) 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.

2. 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?

A) You want the DBCA to bind the partitions to raw devices.
B) You want to provide the DBCA with a list of all the storage devices that are currently bound to a raw interface.
C) You want to configure an ASM diskgroup containing raw devices.
D) You want to set the appropriate raw partition for each database file.

3. View the Exhibit.

A Symmetric RAC and Physical Standby Database configuration is set up for a high availability requirement matching the one in the exhibit with the primary using 'maximum availability' protection mode.
Which two benefits are there for each primary instance in sending its redo to a corresponding standby instance, rather than having all the primary instances sending redo to the same standby apply instance? (Choose two.)

A) The services on the primary would be symmetric allowing performance on each instance to be equal in the event of a switchover or failover to the standby database.
B) Multiple standby instances allow the redo to be written to standby redo logs more quickly than just using a single receiving instance by reducing commit time on the primary instances.
C) If the redo receive load is spread across multiple receiving instances then the primary redo transport is less likely to become a bottleneck.
D) The workloads of the archive processes on the standby instances would be balanced, thereby allowing load balancing across the cluster where the standby resides.
E) Multiple standby instances allow the redo to be applied more quickly by the standby apply instance after the redo has already arrived from the primary.

4. Your company has a combination of high availability and scalability requirements that need to be addressed, and RAC has been discussed as a solution. There are a mix of "off-the-shelf software products and homegrown applications currently in use in your environment that run on single-instance Oracle databases. You have been asked by the IT director to provide an impact analysis report to help assess the impact on applications when migrating to RAC. Which three are among the areas that should be examined for performance impact and application functionality impact or for both? (Choose three.)

A) applications that truncate tables in a data warehouse process
B) client/server type applications that use application local context variables
C) applications that access small tables using the same index occasionally
D) three-tier applications that use application global context variables
E) applications that use SQL profiles created by the ATO optimizer in the SQL Tuning Advisor
F) applications that use large parallel full table scans

5. For which two server metrics can you define thresholds for your services? (Choose two.)

A) APPLICATION_WAIT_TIME
B) SQL EXECUTE ELAPSED TIME
C) PHYSICAL_READ_PER_CALL
D) ELAPSED_TIME_PER_CALL
E) LOGICAL_READ_PER_CALL
F) CPU_TIME_PER_CALL

Solutions: