Testking Oracle 10g 1z0-048
Visited 3401 times, 6 so far today
Exam 1z0-048: Oracle Database 10g R2: Real Application Clusters for Administrators
Exam Number: 1Z0-048
Associated Certifications: Oracle Database 10g: Real Applications Clusters Administrator Certified Expert
Exam Price: $125 USD
Exam Registration: Register
Duration: 120 minutes
Total for both sections
Number of Questions: 63
for both sections combined.
Passing Score: RAC Administration Section: 60%
Cluster Management Section: 60%
Recommended Training and Preparation
Oracle Database 10g: Real Application Clusters
OR
Oracle Database 10g: RAC for Administrators Release 2
NOTE: The exam is based on Oracle Database 10g R2. Those who prepared using the Oracle Database 10g: Real Application Clusters training for Release 1 will need to ensure they are familiar with changes between R1 and R2.
Additional Information & Resources
Oracle Database 10g: RAC Expert Candidate Guide
Exam Retake Policy
Both sections of the exam MUST be passed in order the pass the exam. The final score is not cumulative.
Sample Questions
Exam Topics
Section I : RAC Administration
RAC Installation
[ ]
Install and configure Automatic Storage Management (ASM)
[ ]
Install the Oracle database software
[ ]
Perform pre?database creation tasks
Database Creation
[ ]
Install the Enterprise Manager agent on each cluster node
[ ]
Create a cluster database
[ ]
Perform post?database creation tasks
RAC DB Administration
[ ]
Use Enterprise Manager cluster database pages
[ ]
Define and manage redo log files in a RAC environment
[ ]
Define and manage undo tablespaces in a RAC environment
[ ]
Start and stop RAC databases and instances
[ ]
Modify initialization parameters in a RAC environment
[ ]
Create and manage ASM instances in a RAC environment
[ ]
Create and manage ASM Disk Groups and ASM Files
Backup and Recover a RAC DB
[ ]
Configure the RAC database to use ARCHIVELOG mode and the flash recovery area
[ ]
Configure RMAN for the RAC environment
[ ]
Explain the implications of OracleNet for connecting RMAN for parallel backups
RAC DB Monitoring and Tuning
[ ]
Explain RAC-specific tuning considerations and techniques in an environment involving mixed workloads
[ ]
Tune instance recovery in RAC
[ ]
Determine RAC-specific wait events, global enqueues, and system statistics
[ ]
Diagnose and improve common RAC-specific performance problems involving indexes, sequences and undo
[ ]
Use the Cluster Database Performance pages
[ ]
Use the Automatic Workload Repository (AWR) in RAC
[ ]
Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Services
[ ]
Configure and manage services in a RAC environment
[ ]
Connect your client to a RAC database using services
[ ]
Use services with the Database Resource Manager
[ ]
Use services with the Scheduler
[ ]
Set performance-metric thresholds on services
[ ]
Configure services aggregation and tracing
High Availability of Connections
[ ]
Configure client-side connect-time load balancing
[ ]
Configure client-side connect-time failover
[ ]
Configure server-side connect-time load balancing
[ ]
Use the Load Balancing Advisory (LBA)
[ ]
Describe the uses of Fast Application Notification
[ ]
Describe the uses of server-side callouts
[ ]
Describe the purposes of server- and client-side ONS
[ ]
Configure Transparent Application Failover (TAF)
Design for HA
[ ]
Design a Maximum Availability Architecture in your environment
[ ]
Determine the best RAC and Data Guard topologies for your environment
[ ]
Explain Data Guard Broker configuration files in a RAC environment
[ ]
Decide on the best ASM configuration to use
[ ]
Patch your RAC system in a rolling fashion
RAC Technology Overview
[ ]
Recommend appropriate use and possible application of RAC technology to address scalability, high availability and grid provisioning requirements
Section II : Cluster Management
Oracle Clusterware Installation
[ ]
Describe the capabilities and features of Oracle Clusterware
[ ]
Perform preinstallation and cluster setup tasks
[ ]
Install Oracle Clusterware
[ ]
Describe the different storage options and their implications (OCFS, raw disks, ASM)
Oracle Clusterware Administration
[ ]
Manually control the Oracle Clusterware stack
[ ]
Change voting disk configuration
[ ]
Back up and recover your voting disks
[ ]
Manually back up and recover the OCR, and repair the OCR configuration
[ ]
Explain application VIPs and change VIP addresses
[ ]
Use Clusterware to protect non-Oracle applications
[ ]
Prevent automatic instance restarts
Diagnosing the Oracle Clusterware components
[ ]
Enable and collect diagnostics for Oracle Clusterware
[ ]
Set debugging flags for OCR-related tools
[ ]
Enable Oracle Clusterware debugging
[ ]
Enable tracing for Java-based tools
[ ]
Use Cluster Verify
Node Addition and Removal
[ ]
Add a new node to your cluster database
[ ]
Remove a node from your cluster database
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
PassGuide offers free demo for Certification Exams You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products. Download links:http://demo.passguide.com/downloadRecommended Training about 1z0-048 exam PDF
The following courses are the recommended training for 1z0-048 exam PDF.
1z0-048 Q & A with Explanations
1z0-048 Audio Exam
1z0-048 Study Guide
1z0-048 Preparation Lab
1z0-048 Exam: Freetestking’s Oracle Database 10g R2:Administering RAC PDF
The Oracle Database 10g R2:Administering RAC PDF for preparing for the 1z0-048 exam – Freetestking’s Oracle Database 10g R2:Administering RAC. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.
Question: 1
Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize the access to available listeners?
A. FAILOVER
B. LOAD_BALANCE C. SOURCE_ROUTE
D. TYPE_OF_SERVICE
Answer: B Question: 2
You are working as a DBA in a RAC environment that is available for testing. The RAC environment has all the database files stored in the OCFS file system. You plan to install ASM and move all the database files to ASM to achieve better performance. During the installation,
you selected redundancy level as normal for the disk group being added. What is the reason for
selecting this redundancy level?
A. You want to use hardware mirroring.
B. You do not want to have any mirroring in the disk group.
C. You have two failure groups defined, so you want to use two-way mirroring.
D. You have three failure groups defined, so you want to use three-way mirroring.
Answer: C Question: 3
You are running a two-instance database with six redo log groups defined and decide to add a third thread to support a third database instance on the third node of the cluster. Which three commands would you issue to achieve this using command line administration? (Choose three.)
A. ALTER SYSTEM ENABLE THREAD 3;
B. ALTER DATABASE ENABLE THREAD 3;
C. ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8; D. ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7;
E. ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7; F. ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8;
Answer: B, E, F Question: 4
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?
A. LOCAL_LISTENER
B. REMOTE_LISTENER
C. REMOTE_DEPENDENCIES_MODE
D. PREFER_LEAST_LOADED_NODE_
You have a well-tuned, non-RAC single instance Oracle database with several services, all of which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all
file systems would be shared using Oracle Cluster File System. After the migration, you want to perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC
Page 1 of 46
TK
Exam Name: Oracle Database 10g R2: Administering RAC
Exam Type Oracle
Exam Code: 1Z0-048 Total Questions: 124
database. Which six areas would you monitor to determine whether there are RAC-specific
performance problems after migration? (Choose six.)
A. Interconnect latency
B. Instance recovery time
C. Services with applications that use external tables
D. Services with applications that truncate large tables
E. Services with applications using local context variables
F. Services with query-intensive applications relying on full table scans
G. Services with insert-intensive applications that use Oracle sequences for index keys
H. Services with applications that have occasional queries, using index access on modestly sized tables
I. Services with insert-intensive applications that generate their own keys without Oracle sequences
Answer: A, B, D, F, G, I Question: 6
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.)
A. Check the resource state by using the CRS_STAT command.
B. Check for OCR corruptions by using the OCRCHECK command.
C. Check the alert.log file that belongs to the instance that did not start.
D. Check the alert.log file that belongs to the Oracle Clusterware software.
E. Check if the Oracle Clusterware is functional by using the CRSCTL command.
F. Reboot the node where the failing instance resides to check if the problem is persistent.
G. Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command.
Answer: A, C, D Question: 7
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.
Page 2 of 46
TK
Exam Name: Oracle Database 10g R2: Administering RAC
Exam Type Oracle
Exam Code: 1Z0-048 Total Questions: 124
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. There is less paging each time.
B. The run queue length is going down each time.
C. It takes less time to execute the workload each time.
D. The number of transactions per second is getting higher each time.
E. The database throughput graphic is below the red dashed line during the last execution.
Answer: C, D Question: 8
Which three storage types are suitable as a flash recovery area for an Oracle 10g RAC
database? (Choose three.)
A. Raw volume
B. ASM disk group
C. Local file system
D. Cluster file system
E. Shared NFS directory
Answer: B, D, E Question: 9
After the cluster database has been successfully created, several postinstallation tasks should be completed. Identify three of them. (Choose three.)
A. Create the ASM instance. B. Back up the root.sh script.
C. Initialize the cluster backup procedure.
D. Set up additional required user accounts.
Page 3 of 46
TK
Exam Name: Oracle Database 10g R2: Administering RAC
Exam Type Oracle
Exam Code: 1Z0-048 Total Questions: 124
E. Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config
database
Dowload PassGuide Practice Test Questions
8 Comments on “Testking Oracle 10g 1z0-048”