The Oracle 9i test for application developers is intended to assess the knowledge base of those working and/or intending to work as a developer with the Oracle 9i database. The topical areas included are PL/SQL Control Structures, optimizing performance, object and RDBMS extension in Oracle 9i, using code units and the specific features of Oracle 9i, among others. This test is not appropriate for database administrators or users of Oracle 9i. Tests Oracle 8 for Developers, Oracle 8 for Database Administrators, and Oracle 8.i are also available. Total Questions 54 Question Types Multiple Choice Competencies Tested Oracle 9i-Specific FeaturesPL/SQL Control StructuresPL/SQL CommentsDynamic SQLOptimizing Performance using Oracle 9iThe OBJECT RDBMS Extension in Oracle 9iWriting SQL in PL/SQLException Handling in Oracle 8i and HigherCollections in Oracle 8i and HigherOracle 9i Using Code Units Tasks Tested PL/SQL Programming in Oracle 9iIf-Then-Else Control StructureCase-End Control StructureLoop Control StructureDocumenting CodeWriting Code for Runtime CompilationBulk BindingUsing Objects in Oracle 8i and HigherUsing CursorsUsing PseudocolumnsControlling TransactionsHandling ExceptionsUsing Collections
