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

The following are some of the tasks that are performed during a RAC implementation: 1) Setting the Oracle database-related environment variables 2) Creating a password file 3) Installing Management Service and Management Agent 4) Creating and editing the Raw Device Mapping file 5) Creating an ASM instance 6) Creating the Oracle Cluster Registry (OCR) file 7) Implementing the Transparent Application Failover (TAF) policy 8) Creating database services Identify the tasks that can be performed using the DBCA, or performed by the DBCA, during database creation in the RAC implementation.

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

James works as a senior DBA for a finance company. He plans to implement a test RAC
environment. As per his plan, a three-node RAC would be implemented on a Windows platform,
with the following points related to the storage of files:
1) A single Oracle home would be shared by all the nodes.
2) The data files will extend automatically because the autoextend feature will be enabled.
3) The Oracle binaries and all the database files would be stored in a single file system.
4) The hardware RAID is used to support high availability.
These are the some of the storage options available for RAC implementation:
Option 1:Use OCFS with ASM Option 2:Use ASM and not OCFS Option 3:Use OCFS and not ASM Option 4:Use neither OCFS, nor ASM
Which storage option would you suggest for this plan?

Several steps must be followed to successfully add a new node to your cluster database. Assuming that a UNIX platform is used, which of the three steps below are correct? (Choose three.)

Your network administrator wants to know why you need extra IP addresses for your Oracle Real Applications Cluster now that you are upgrading from OracleSi to Oracle 10g. Which four statements would you use to explain to your network administrator the reason for requiring extra IP addresses? (Choose four.)

You are migrating a single-instance Oracle database to RAC. The data files and Flash Recovery Area would be migrated to ASM using the RMAN commands BACKUP AS COPY DATABASE and BACKUP RECOVERY AREA, and stored in an ASM diskgroups called +DB_DG and +FR_DG. The DB_CREATE_FILE_DEST parameter would be set to +DB_DG and the DB_RECOVERY_FILE_DEST parameter would be set to +FR_DG.
What are the three best options for the location of your archivelogs so that they may be used properly for recovery without DBA intervention? (Choose three.)

On a UNIX platform, which three processes are required to be running on all nodes before initiating a cluster database creation? (Choose three.)

Which two statements regarding Oracle Clusterware are correct? (Choose two.)

You have attended a user group presentation on RAC and based on what you have learned you feel that your company would benefit from having the RAC option to meet its Oracle database requirements in several ways. Your manager does not know much about RAC and asks you to create a presentation to the team explaining RAC, and whether it should be implemented in your installation. Which three statements explain the benefits and implications of RAC? (Choose three.)

Which three statements regarding the management of Oracle Cluster Registry (OCR) on a UNIX platform are true? (Choose three.)