1 / 58

PWB505 - How To Prepare for and Pass Your PowerBuilder Certification Exams

PWB505 - How To Prepare for and Pass Your PowerBuilder Certification Exams. Sam Lakkundi Principal Instructor lakkundi@sybase.com / 978-287-1692 August 6 th . 2003. Agenda - What we will cover. Introduction to the exams (General) PB - 9 Professional : What do I study ?

kanan
Download Presentation

PWB505 - How To Prepare for and Pass Your PowerBuilder Certification Exams

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PWB505 - How To Prepare for and Pass Your PowerBuilder Certification Exams Sam Lakkundi Principal Instructorlakkundi@sybase.com / 978-287-1692August 6th. 2003

  2. Agenda - What we will cover • Introduction to the exams (General) • PB - 9Professional: What do I study ? • PB - 9ProfessionalSample questions • PB - 7 Professional: What do I study ? • PB - 7 Professional Sample questions • Secrets on the Questions

  3. Introduction To The Exams

  4. Class Abstract - Target Audience • This session is a short discussion on preparing for the PB exams. • The focus on this presentation is the PowerBuilder 9 exam • The student should have at least 8 months of experience with PB programming for this associate exam. • Techniques and suggestions for studying for the exam will be covered. • This session as well as our one day class will NOT reveal any actual questions that the student will encounter on the exam. However, the types of questions will be covered.

  5. Introduction to the exams Basic PB Certifications CSP-PB PowerBuilder 7 - Sybase Certified Associate PowerBuilder 7 - Sybase Certified Professional PowerBuilder 8 - Sybase Certified Associate PowerBuilder 9 - Sybase Certified Professional

  6. Introduction to the exams Where do I take the exams? Call 1-800-8-SYBASE choose Education menu or At any Prometric (800-407-3926) testing center or visit www.2test.com

  7. Introduction to the exams When do I know if I passed? Immediately. After taking the test, your score is immediately printed out and sent to Sybase for record keeping. CSP Associate PB 7.0 75 % CSP Professional PB 7.0 75 % CSP Associate PB 8.0 70 % CSP Professional PB 9.0 62 %

  8. Introduction to the exams What if I fail? The student is allowed to fail any of the two tests two times. If the student fails any of the two tests for the second time, the exam may not be taken again for a period of thirty days.

  9. Introduction to the exams When do I need to be re-certified? Associate: Every version. Just take the new Associate exam. Professional: Every version. Just take the new Professional exam. As of version 7.0 there are no more migration exams.

  10. Introduction to the exams • What are my benefits? • Industry Recognition • Use of Logo on business cards • Official Certificate • Differentiator for employers and promoters

  11. Introduction to the exams What Does Sybase Certification Offer You? • Increases your job advancement opportunities • Provides a standard, tangible way of measuring your technical skills • Provides you with a goal for self-improvement and self-development • To design and implement real-world solutions, which will make you valuable to your clients and your team

  12. Introduction to the exams How does one prepare for an exam? • Customer Education: Schedules available at www.sybase.com/education • Experience with products • Make sure to go through the study guide in great detail • Practice Exams: Available through e-Shop • http://e-shop.sybase.com or calling 1-800-8-SYBASE • Certification preparation class

  13. Introduction to the exams CSP - PB Professional9.0 Completion of one multiple choice exam. Exam contains sixty multiple choice questions. This exam covers fundamental/advanced PB questions. 90 minutes to complete exam

  14. Additional Resources: SDN Presents CodeXchange Share PowerBuilder 9 Code and Tools • New SDN feature enables community collaboration • Download samples created by Sybase • Leverage contributions of others to exploit PBNI (i.e. PBNI CommonDialog, PBNI OLEObject utilities) • Contribute your own code or start your own collaborative project with input from other PowerBuilder experts • Any SDN member can participate • Log in using your MySybase account via SDN • Join the collaboration already underway • http://powerbuilder.codexchange.sybase.com or via SDN at www.sybase.com/developer • SDN & CodeXchange at TechWave • Technology Boardwalk • Sybase Booth Theater

  15. PB - 9Professional: What do I study ?

  16. Course Maps Course Maps – PB 9Professional We recommend courses: Fast Track to PowerBuilder 9.0 or Moving to PowerBuilder 9.0 Using DataWindows Advanced PowerBuilder 8.0 Controls

  17. Introduction to the PB 9Professional Exam This exam tests PowerBuilder development skills at the Professionallevel. Developers taking this test should have approximately 8 months to one year of PowerBuilder development experience, and demonstrate mastery of concepts taught in the PowerBuilder 9.0 FastTrack course. Candidates must also master the concepts and objectives taught in the Moving to PowerBuilder 9.0 and the DataWindow Objects course. As a supplement to the Instructor led courses, candidates may use the PowerBuilder 9.0 practice exam to prepare.

  18. What do I study? - PowerBuilder 9Professional 1. Relational Database – 1 Question 2. Application – 2 Questions 3. Debugger – 1 Question 4. DataWindow – 7 Questions 5. Function – 2 Questions 6. Library – 1 Question 7. Menu – 1 Question 8. Pipeline – 1 Question 9. Project – 1 Question *Note we will cover 9 important sections in this discussion

  19. What do I study? - PowerBuilder 9Professional 10. User Object – 3 Questions 11. PowerScript Controls – 7 Questions 12. PowerScriptDataWindows – 9 Questions 13. PowerScript Object Orientation – 15 Questions 14. PowerScript Windows – 2 Questions 15. Components – 2 Questions 16. 4 GL WebDataWindows – 3 Questions 17. 4 GL Web Pages – 2 Questions 18. 4 GL JSP Pages – 1 Questions *Note we will cover sections 1 – 9 in this discussion

  20. What do I study? (PowerBuilder 9Professional) 4. DataWindows – 7 Questions Understand techniques to ensure data consistency and concurrency using DataWindow painter options. Identify how to use a DataWindow button to perform a predefined or customized functionality. 6. Library – 1 Question Know when to use a PBD vs. a DLL

  21. What do I study? (PowerBuilder 9Professional) 7. Menu – 1 Question Know the similarities and differences between menus and other window controls. 9 . Project – 1 Question Be able to describe the different uses of the PowerBuilder Projects. 10. User Object – 3 Questions Learn how to include Non-visual objects in an application.Know how to define user objects - class and visual. Be readyto describe benefits of using NVOs.

  22. What do I study? (PowerBuilder 9Professional) Most questions are from here! 11. PowerScript Controls – 7 Questions Know the code to manipulate and access the data contained in PowerBuilder controls. Know how to use Rich TextEdit controls. Know how to create a ListView, TabView, RTF and OLE controls. Know the purpose of Uniform Data Transfer (UDT). Know the uses of uses for non visual DataWindows. Know how to automate ActiveX controls. 8. Pipeline – 1 Question Understand the uses for a Pipeline, and how to implement one.

  23. What do I study? (PowerBuilder 9Professional) POWERSCRIPT 12.PowerScript DataWindows – 9 Questions a) Understand uses for non visual DataWindows. b) Make sure to understand code involving DataWindowevents and functions. c) Know techniques for manipulating DataWindow Buffers. d) Know sequence of events when a DataWindow button is clicked. e) Know how to debug datawindows. f) Know the techniques involved in managing transactions and concurrency in a DataWindow. g) Know how to handle dB errors involving DataWindow’s. h) Know which file types are available when using the SaveAs( ) function on aDataWindow.

  24. What do I study? (PowerBuilder 9Professional) POWERSCRIPT (contd.) 13.PowerScript Object Oriented – 15 Questions • Know your A.P.I.E. • Abstraction • Creating a class from a real world object. • Polymorphism • Same interface different implementation. • Inheritance • Using the methods and properties of one class to • Encapsulation • Enclosing all related methods and properties into a single class.

  25. PB - 9 Sample Questions

  26. Sample Questions - Painters and Tools • The Standard Class User objects that can be created to handle errors in script are: • Throwable • Message • Exception • DWRuntimeError • RunTimeError Correct Answers: A, C & E

  27. Sample Questions - Painters and Tools Where is the library list for a PowerScript application stored? • PB.INI • Windows registry • Workspace (.PBW) • Target (.PBT) • PowerBuilder Library (.PBL) Correct Answers D

  28. Sample Questions - PowerScript • The FindItem() function is used in which of the following controls? • Tab • Graph • TreeView • DataWindow • HProgressBar Correct Answer: C

  29. Sample Questions - PowerScript • Creating a self contained class, defined with its own methods and properties where the implementation of the class is hidden from other classes is called: • Polymorphism • Encapsulation • Inheritance • OverLoading • Abstraction Correct Answer: B

  30. Sample Questions - PowerScript • Which control is used for multiple selections? • DropDownListBox • Radio Buttons • ListBox • TreeView • Multilineedit Correct Answer: C

  31. Sample Questions - PowerScript • In order to locate the position of the final occurrence of the string “, ” in the string variable ls_fullname you would use which function? • LastPos() • Find() • Pos() • Left() • Match() Correct Answer: A

  32. Sample Questions - Components • The Concurrency property on an EAServer component is synonymous with which of the following terms? • Instance Pooling • Thread Safe • Shared • Automatic Demarcation • StateFull Correct Answer: B

  33. Sample Questions - Components • What is the distributed architecture standard for invoking methods remotely that is both language and platform independent? • IIOP • DCOM • HTTP • Corba • Java RMI Correct Answer: D

  34. Sample Questions - 4GL Web Pages • Which event on a Button placed on a 4GL Web Page can be used to execute the DataWindow function Update()? a. OnClick b. AfterAction c. ServerAction d. FirstTime e. OnLoad Correct Answer: C

  35. Sample Questions - 4GL Web Pages • Select the correct items from the list that can be part of a Web Target. • Cascading Style Sheet • User Object • HTML page • .GIF file • DataWindow Correct Answers: A, C & D

  36. Sample Questions - 4GL Web Pages • A component can be bound to a single line edit of a 4GL Web, page if which of the following conditions is true: • The component has at least one public instance variable. • The component has at least one public method. • The component has a method that starts with the word ‘set’ or ‘get’. • The component must be statefull. • The single line edit must have the same name as an instance variable on the component. Correct Answer: D

  37. PB - 7 Professional: What do I Study ?

  38. Introduction to the exams - PowerBuilder 7 Prof. PB 7 Professional The PowerBuilder Professional Exam will test whether a PowerBuilder developer has the knowledge to be in the top of their field. A developer should have at least 1.5 years of PowerBuilder experience. Also, a developer should be able to demonstrate competence in the subjects covered in the following classes: Fast Track to PowerBuilder 7.0, Using the DataWindow, Advanced PowerBuilder Controls 7.0, and Building Applications using PowerBuilder and EA Server. A developer should also be able to implement the objectives outlined in his document.

  39. Introduction to the exams - PowerBuilder 7 Prof. 1. Language Techniques 2. User Interface Techniques 3. Data Access Techniques 4. Developing Multi-tier Applications 5. DataWindow 6. Internet Techniques 7. General Techniques 8. Menu 9. Pipeline

  40. Introduction to the exams - PowerBuilder 7 Prof. • 1. Language Techniques • a) Know the different components and functionality of scripting tools provided in PowerBuilder. • b) Know the expressions for DataWindow and external objects using dot notation. • c) Know the different scopes and access levels of methods and variables. • d) Describe how to construct DataWindow expressions and the implications of using them. • 2. User Interface Techniques • Know how to use a Tab Control, TreeView, or ListView control to solve a specific business problem. • b) Identify the Drag and Drop features of PowerBuilder

  41. Introduction to the exams - PowerBuilder 7 Prof. 3. Data Access Techniques a) Know the correct use of Embedded SQL in PowerScript. b) Know methods for dynamic manipulation of DataWindows c) Know DataWindow query capabilities for users. d) Know how to use a DataStore object e) Describe ActiveX properties, methods, and events. f) Demonstrate how to automate ActiveX controls. 4. Developing Multi-tier Applications a) Know how to build business objects, which are separate from the user interface. b) Know the lifecycle of a component on Jaguar. c) techniques to troubleshoot a PowerBuilder component on Jaguar d) Know features of the Object Browser

  42. Introduction to the exams - PowerBuilder 7 Prof. 5. Internet Techniques a) Describe the use of a component server in an internet application.b) Describe the HTML DataWindow and how it can be utilized in an internet application. c) Know how to create an HTML page that displays a report d) Evaluate the correct architecture for a specific business application. f) Identify the properties of the DataWindow object that are related to HTML generation 6. General Techniques a) Identify the components that define different PowerBuilder projects. b) Identify ways to manage application settings using initialization files and the registry

  43. PB - 7 Professional- Sample Questions

  44. PowerBuilder 7 Professional: Sample questions: • What is the effect of changing the DBParm StaticBind from 0 to 1? • A) The object is forced to remain in memory cache. • B) Performance may improve when retrieving DataWindows. • C) Performance may improve when updating DataWindows. • D) Input parameters are not bound to the SQL statement. • E) None of the above

  45. PowerBuilder 7 Professional: Sample questions: • Question: Identify one statement below that is NOT true for a child window: • a. Can have a title bar • b. Can be minimized or maximized • c. Can be resized. • d. Can be considered the active window

  46. PowerBuilder 7 Professional: Sample questions: Which of the following are ways to deploy a PowerBuilder component to a Jaguar Server? a. Save the user object with Live Editing enabled. b. Copy the PBL containing the user object to the Jaguar server. c. Build the Jaguar Component Project. d. Generate and execute the IDL file from the Project Wizard. e. Run the Jaguar Proxy Wizard.

  47. PowerBuilder 7 Professional: Sample questions: Which of the following is not an inherent advantage of distributed computing a. Consolidation of business logic on application servers b. Ease of design and implementation c. Partitioning and reuse of application functionality d. Scalability of solutions to large numbers of users e. Increased security via centralization of access to data

  48. Secrets on the Questions

  49. Questions on the exam • Can have multiple answers. • Will NOT ask a question that identifies a weakness of PowerBuilder • No intentionally trick questions. • No true/false - everything is multiple choice. • Will NOT have answers that have made up functions, properties, or object names. • Cover the material of the listed courses plus your own experiences.

  50. Bad question • This type of question will not be on the exam: • The Rows of a DataWindow can be saved in which of the following formats: • A. Static HTML • B. XML • C. Spreadsheet • D. Tab delimited text • E. HTML and JavaScript

More Related