HP1-850
- Sunday, September 21, 2008, 19:29
- Exam Topics
- 4 views
- 2 comments
Integrating Oracle9i with HP Platforms- Windows
Exam HP1-850 Preparation Guide
Purpose of the Exam Preparation Guide
The intent of this guide is to set expectations about the content and the context of the exam and to help you prepare for the exam. In this guide, you will find references to resources that will assist you in preparing for the exam.
Studies conducted by HP and Prometric show that a combination of course attendance and self-study maximizes the likelihood of passing the exam on the first attempt.
Intended Audience for the Exam
The Integrating Oracle9i with HP Platforms- Windows exam is intended for technical audiences with four or more years of industry experience. Examples of job roles include:
? HP partner presales technical solutions architects and consultants
? HP partner implementation engineers
? Customer IT staff
? Field technical presales
? Customer services personnel
? HP technical instructors
Certification Requirements
The Integrating Oracle9i with HP Platforms-Windows exam is one of the core requirements to be certified as an Accredited Systems Engineer (ASE) or as Accredited Integration Specialist (AIS).
Rev. 2.41 EPG for Windows – 1
Integrating Oracle9i with Compaq Platforms Exam Preparation Guide
Exam Content Overview
General areas of content include:
? Relational Database Fundamentals WBT
? Oracle9i Architecture
? Platform Planning: Processors, Memory, and Network
? Platform Planning: Disk
? HP Sizers for Oracle9i
? Operating System Monitoring and Tuning for Windows 2000
? ProLiant Performance Analyzer
? Introduction to Oracle9i Monitoring and Tuning
? Wait Event-Based Tuning Using StatsPack
? Hands-On Labs
Exam Registration
? Register online at www.2test.com
? Locate local testing sites at www.Prometric.com
EPG for Windows – 2 Rev. 2.41
Exam Details
This Integrating Oracle9i with HP Platforms-Windows, HP1-850 is a beta exam. This means that you will see all the questions in the exam pool. During the final
“live” exam, you will see only those items that remain after the beta test.
You will receive a score report with your results after beta testing is complete. If you do not pass the beta, you can use the report to identify areas of strength and learn about areas to improve upon for the live exam.
Please allow 2 to 3 months, after you have taken the beta exam, to receive your score report. If the beta is extended beyond 6 weeks, you will receive your score report after the beta is closed.
At the beginning of the exam, you will be asked to answer several survey questions. The survey has been designed to assist the exam development team
define the final exam forms and set the passing score. Your honest responses will assist the exam team in properly tailoring this exam to the appropriate audience.
? Number of items: 202
? Item types: multiple choice, exhibits
? Time commitment: 4 hours
? Reference Material: No on-line or hard copy reference material will be allowed at the testing site.
Comments on the Exam:
During the exam, you will be able to make specific comments about the test items
(i.e., accuracy, appropriateness to audience, etc). HP welcomes these comments as part of our continuous improvement process.
Rev. 2.41 EPG for Windows – 3
Integrating Oracle9i with Compaq Platforms Exam Preparation Guide
Exam Objectives
This section provides the objectives that are represented on the exam. Use this information to guide your study and to check your readiness for the exam.
Relational Database Fundamentals WBT (Self-Study Prerequisite)
? Describe how a relational database management system (RDBMS) stores and retrieves data.
? Discuss how to access data stored in the database.
? Explain the aspects of an RDBMS that enable its high-performance capabilities—indexing, hashing, caching, query optimization, and data clustering.
? Identify various aspects of security and data protection.
? Explain database concurrency and list concurrency control mechanisms.
? List the properties of a database that ensure data integrity.
? Define two primary database environments: OLTP and data warehousing.
? Describe each database environment, and list and explain their:
• Predominant activities
• Characteristics
• Tuning goals
Module 1: Oracle9i Architecture
? Describe the Oracle9i architecture.
? List the Oracle9i database files and define their purpose.
? Explain the purpose of the system global area and identify its components.
? List background processes and explain their function.
? Compare server process modes used with Oracle9i.
EPG for Windows – 4 Rev. 2.41
Module 2: Platform Planning: Processors, Memory, and Network
? Describe processor-planning concepts: different types of transaction execution.
? Describe processor-planning concepts: database environment impact on processor planning.
? Describe processor-planning concepts: processor performance analysis.
? Explain memory-planning competencies: when to size memory.
? Explain memory-planning competencies: initial memory recommendations.
? Explain memory-planning competencies: operating system, third-party applications, and Oracle memory requirements.
? Describe network planning.
Module 3: Platform Planning: Disk
? Explain how the application I/O workload affects disk subsystem planning.
? Describe RAID and disk caching and their impact on disk performance.
? Provide an overview of storage subsystem performance planning.
? Explain what is involved in individual storage subsystem component performance planning.
? Describe how the different planning and performance monitors are used.
? Describe techniques that improve performance at the logical disk design level.
Module 4a: Compaq Sizers for Oracle9i
? Define the ProLiant Transaction Processing Sizer for Oracle9i.
? Describe the ProLiant Transaction Processing Sizer for Oracle9i installation and configuration.
? Explain the interview process.
? Describe the sizer output and actions you can take on the result set.
Module 5a: Operating System Monitoring and Tuning for Windows
2000
? List and explain the Windows 2000 monitoring tools.
? Describe how to monitor and tune memory, disk subsystem, processor, and network usage.
? Adjust the operating system recovery settings to avoid server recovery delay.
Rev. 2.41 EPG for Windows – 5
Integrating Oracle9i with Compaq Platforms Exam Preparation Guide
Module 6a: ProLiant Performance Analyzer
? Explain the function of the ProLiant Performance Analyzer.
? Describe the ProLiant Performance Analyzer architecture.
? List and describe monitored objects: processors, memory, and I/O subsystem.
? Explain how to connect to the ProLiant Performance Analyzer and how to add monitored servers.
? Describe the inventory, status, and graph windows for each monitored subsystem.
? Demonstrate the ProLiant Performance Analyzer functionality using the supplied example.
? List enhancements proposed for the next version.
Module 7: Introduction to Oracle9i Monitoring and Tuning
? Explain how to monitor and tune Oracle9i memory structures.
? Describe how to monitor and tune Oracle9i instance recovery and I/O.
? List and describe StatsPack and Oracle Enterprise Manager Diagnostics Pack.
Module 8: Wait Event-Based Tuning Using StatsPack
? Outline and discuss the tuning process.
? Discuss the system performance and the focus of performance tuning.
? Define a bottleneck and explain what system components are likely to become bottlenecks.
? Differentiate between system snapshot tools and time span tools.
? Explain typical observations from collected data.
? Contrast ratio-based tuning with wait event-based tuning.
? Describe Oracle wait events.
? Describe BSTAT/ESTAT and StatsPack.
? Explain StatsPack installation, usage, and reporting.
Troubleshooting
Demonstrate competencies learned in a hands-on labs.
EPG for Windows – 6 Rev. 2.41
Recommended Training and Study References
This section lists training courses, resources, and documents that can help you acquire a majority of the knowledge and skills needed to pass the exam. You must also gain the practical experience outlined in this guide.
You are not required to take the courses listed in this section. However, HP
strongly recommends that you attend the classes, participate in the class labs, and thoroughly review all course material and documents before taking the exam, even
if you believe you have sufficient on-the-job experience.
Important
HP does not guarantee or represent that all items on the exam are taken from the instructor-led course or course materials. Some items require
understanding of several interrelated topics to answer correctly. Other items rely on assumed industry experience and prerequisites as identified in this exam preparation guide. Some items are referenced in materials other than
course materials, as indicated in this document.
Instructor-Led Training
Use the information in this guide and the practical experience you have gained to determine your need for the instructor-led training.
Title Course Title Enrollment Instructions
Integrating Oracle9i with
Compaq Platforms
Oracle9i Integration with
HP Platform – Windows
Refer to the certification requirements website for your region for course registration information.
The following materials included with the instructor-led training course will help
you prepare for the exam:
? Student guide
? Lab guide
? Lab scripts (included on the course Companion CD-ROM)
? Related articles (included on the course Companion CD-ROM)
Rev. 2.41 EPG for Windows – 7
Integrating Oracle9i with Compaq Platforms Exam Preparation Guide
Prerequisites
The following list of prerequisites or equivalent knowledge is highly
recommended to complete the course and successfully pass the certification exam.
? Oracle9i Database Administration Fundamentals I – Oracle ILT course ID D13084, duration 5 days, http://www.oracle.com/education/course_listings/database/index.html?dba_or
a9i.html
? Oracle9i Database Administration Fundamentals II – Oracle ILT course ID D13161, duration 5 days, http://www.oracle.com/education/course_listings/database/index.html?dba_or
a9i.html
Web-Based Training
The Relational Database Fundamentals WBT or equivalent knowledge is required for this course.
HP Documentation
Donwload Free PassGuide Braindumps-The Most Realistic Practice Questions and Answers,Help You Pass any Exams? Articles included on the course Companion CD-ROM
? Documentation available with products, tools and utilities discussed in the course
Other Reference Material
? Articles included on the course Companion CD-ROM
? Oracle9i Enterprise Edition documentation, available from Oracle
Corporation
EPG for Windows – 8 Rev. 2.41
Sample Exam Item Types
The items in this section are intended to help you understand the various types of items you will see during the exams. These items are not intended to be used as a measurement of your ability to pass the exam.
Sample Item 1: Single-Answer Multiple Choice
What is another name for the system catalog?
a. Data dictionary b. Bitmap index
c. Page header d. Data cluster
Answer: a
Sample Item 2: Multiple-Answer Multiple Choice
Which two instance architecture features are associated with an Oracle instance running in the Linux environment? (Choose two.)
a. Single process per instance
b. Multiple threads per instance c. Single thread per instance
d. Multiple processes per instance e. Dedicated memory per instance f. Shared memory per instance
Answer: d and f
Rev. 2.41 EPG for Windows – 9
Integrating Oracle9i with Compaq Platforms Exam Preparation Guide
Sample Exam Questions
This set of sample exam questions will help you become familiar with the types of questions on the exam. Because the questions do not cover every test objective,
they are not intended to test your readiness for the exam.
None of these questions is contained on the actual exam. The actual exam questions could be more or less difficult than this set of questions.
After answering these questions, check your responses by using the answer key provided at the end of this section.
1. What is another name for the system catalog?
a. Data dictionary b. Bitmap index
c. Page header d. Data cluster
2. If one transaction holds a shared lock, what type of lock can other transactions obtain on the same data set?
a. A shared lock
b. An exclusive lock
c. Either a shared or an exclusive lock
d. Neither a shared nor an exclusive lock
3. Which tool allows you to edit the information stored in the SPFILE.ORA
file?
a. Oracle Database Configuration Utility b. Oracle Enterprise Manager
c. Oracle Net Configuration Assistant d. Text editor
4. System scale-up refers to a method of:
a. Improving database availability by introducing redundant components.
b. Improving performance by introducing additional hardware resources within the same system.
c. Improving performance by introducing clustered servers.
d. Increasing the database capacity by employing storage virtualization.
EPG for Windows – 10 Rev. 2.41
5. Which parameter determines the size of the redo log buffer?
a. LOG_BUFFER
b. LOG_SIZE
c. REDO_BUFFER
d. REDO_LOG_SIZE
6. Which database environment has a high ratio of disk drives to disk controllers?
a. Batch processing b. Data warehousing c. Decision support
d. Online transaction processing
7. Which statement is false?
a. Read caching boosts performance in high-bandwidth application environments.
b. Database systems typically do not reuse information stored in the read cache of the disk controller.
c. Read caching can significantly boost the redo log performance.
d. Write-back caching that is properly protected can significantly boost performance of the redo log writes.
8. Which configuration is the least desirable when configuring a high- performance database server?
a. Redo log files alternating two physical disks
b. Redo log files and data files on physically different disks c. Redo log files on an ADG volume
d. Redo log files physically separated from the page file and the operating system files
9. Where can you save the configurations recommended by the ProLiant
Transaction Processing Sizer for Oracle9i?
a. Diskette or local hard disk b. NVRAM
c. Online ActiveAnswers repository d. Server Profile Diskette
Rev. 2.41 EPG for Windows – 11
Integrating Oracle9i with Compaq Platforms Exam Preparation Guide
10. Which network setting provides the most effective memory resource
allocation for applications with low network usage and their own data cache?
a. Maximize data throughput for file sharing
b. Maximize data throughput for network applications c. Minimize memory used
d. Balance
11. What is the proper sequence of commands used to configure server tasking?
a. Start ? Settings ? Control Panel ? System ? Advanced ?
Environment Variables
b. Start ? Settings ? Control Panel ? System ? Advanced ?
Performance Options
c. Start ? Settings ? Control Panel ? System ? Advanced ? Startup and Recovery
d. Start ? Settings ? Control Panel ? System ? Advanced ?
User Profiles ? Change Type
e. Start ? Settings ? Network and Dial-Up Connections ? Advanced ?
Advanced Settings
12. Which Oracle view should you query to determine the data dictionary cache hit rate?
a. V$LIBRARYCACHE
b. V$ROWCACHE
c. V$SESSTAT
d. V$SGASTAT
13. You determine that the redo buffer allocation retries are high. What should you do?
a. Increase the number of the redo log files.
b. Increase the redo log buffer size using the LOG_BUFFER parameter and restart the instance.
c. Increase the redo log buffer size using the REDO_BUFFER_SIZE
parameter and restart the instance.
d. Increase the size of the redo log files.
EPG for Windows – 12 Rev. 2.41
14. You query the DB_CACHE_ADVICE view and retrieve the results listed in the following table.
Cache Size
(MB)
Buffers Estimated Physical
Read Factor
Estimated Physical
Reads
212 26,614 1.74 17,850,847
243 30,416 1.33 13,720,149
273 34,218 1.13 11,583,180
304 38,020 1.00 10,282,475
334 41,822 .93 9,515,878
364 45,624 .87 8,909,026
395 49,426 .83 8,495,039
What is the current size of the database buffer cache?
a. 212MB b. 273MB c. 304MB d. 364MB e. 395MB
15. You query the DB_CACHE_ADVICE view and retrieve the results listed in the following table.
Cache Size
(MB)
Buffers Estimated Physical
Read Factor
Estimated Physical
Reads
212 26,614 1.74 17,850,847
243 30,416 1.33 13,720,149
273 34,218 1.13 11,583,180
304 38,020 1.00 10,282,475
334 41,822 .93 9,515,878
364 45,624 .87 8,909,026
395 49,426 .83 8,495,039
If you decrease the current database buffer cache by 61MB, what would be
the increase in database buffer cache misses?
a. 13% b. 33% c. 74% d. 100% e. 125%
Rev. 2.41 EPG for Windows – 13
Integrating Oracle9i with Compaq Platforms Exam Preparation Guide
16. In which section of the Oracle StatsPack report can you find the number of
transactions per second?
a. Instance and cache information b. Instance efficiency percentages c. Load profile
d. Top 5 timed events e. Wait events
17. According to a recommendation from Oracle, which format should you use for the Global Database Name?
a. Domain.name
b. Domain.name.port
c. Domain.name.port.IP_address d. Name.domain
e. Name.port
18. Which RAID level provides the highest performance and data protection for the Oracle redo log files?
a. JBOD
b. RAID 0
c. RAID 1+0
d. RAID 5
e. ADG
19. Which command displays the current status of the diskperf option?
a. diskperf
b. diskperf -?
c. diskperf –show d. diskperf –Y
20. Three of the following scenarios will cause the Oracle StatsPack installation
to fail. Which scenario will enable the StatsPack installation to succeed?
a. StatsPack is installed using the SQL*Plus utility.
b. StatsPack is installed using the Server Manager tool.
c. The SYSTEM tablespace is specified as the default tablespace for
StatsPack.
d. A blank password is specified for the PERFSTAT user.
EPG for Windows – 14 Rev. 2.41
21. What percentage of the Oracle9i instance memory should be initially
allocated to the aggregate process global area (PGA) size in data warehousing environments?
a. 20% b. 40% c. 50% d. 60% e. 80%
Rev. 2.41 EPG for Windows – 15
Integrating Oracle9i with Compaq Platforms Exam Preparation Guide
Conclusion
HP wishes you success in the HP Certified Professional program and in passing the exam for which you are preparing.
EPG for Windows – 16 Rev. 2.41
Appendix A: Answers to Sample Exam Questions
Question Answer Question Answer
1. A 12. B
2. A 13. B
3. B 14. C
4. B 15. B
5. A 16. C
6. D 17. D
7. C 18. C
8. C 19. A
9. C 20. A
10. B 21. C
11. B
The HP HP1-850 certificates give you possibility to work in any country of the world because they are acknowledged in all countries equally. This HP HP1-850 torrent certificate helps
not only to improve your knowledge and skills, but it also helps your career, gives a possibility for qualified usage of HP HP1-850 exam products under different conditions. The
majority of companies in the sphere of information technologies require the presence of HP HP1-850 exams for the work in the company, and that makes obtaining this HP 050-649-(606a)
certificate necessary. Many IT specialists were not able to obtain the real HP HP1-850 certificate from the first attempt, which was the result of poor preparation for the
examination, using preparatory HP HP1-850 study guide of poor quality.
The PassGuide leader among the providers of HP HP1-850 preparatory materials is products such as HP HP1-850 vce pdf Braindumps, HP HP1-850 Tutorial, HP HP1-850 Exam Questions with Answers, HP HP1-850
Trainings, HP HP1-850 Test Online Simulations Course and free PDF. It obtained its leadership and trust of the users from the very beginning of its work on the HP HP1-850 training
materials market. All the HP HP1-850 value pack aids have been created by people who are personally familiar with actualtests HP HP1-850 Preparation Labs and who know all the
difficulties and popular mistakes made by those who take a HP HP1-850 . The entire material is logically composed in such a way that everything becomes easy to understand for
anyone. full download Many HP HP1-850 guides include audio and video material. It is really easy to acquire HP HP1-850 exams because of great variety of methods of payment.
pass4sure testking HP HP1-850 transcender PassGuide Testinside rapidshare 4shared links
Free down:Testkking Hp Exams
Free down:Pass4sure Hp Exams
more info:www.hpexams.com
|
Type |
Exam Bible | New Questions & Answers |
Latest Updated |
Download link |
| All Certbible 's Exam Dumps |
597 |
1 days ago | Available |
PassGuide Training Materials & Practice Tests
About the Author
Free Certification Exam Download has written 10018 stories on this site.
If you have any doubts about legality of content or you have another suspicions, feel free to contact us:CertGuard@Gmail.com
2 Comments on “HP1-850”
Trackbacks
- hp exams | Free Latest Testking Pass4sure Actualtest Certification Exams Dumps
- FRee Latest TestInside VCE Dumps » Blog Archive » down testinside actualtest hp exams
Write a Comment
Gravatars are small images that can show your personality. You can get your gravatar for free today!
