This Oracle 11g Release 2 for Developers test is designed to assess the knowledge of a candidate concerning Oracle 11g. Test takers should have a strong understanding of Oracle PL/SQL. The topics covered include exception handling, packages, scope and visibility, architecture, advanced utility, security enhancements, indexes, performance tuning, triggers, PL/SQL subprograms, collection types, and cursors. It is appropriate to administer this assessment to developers with a year or more experience with Oracle 11g Release 2. Total Questions 41 Question Types Multiple Choice Competencies Tested Oracle11g FeaturesCursorsPerformance TuningCollection Types and IndexesPL/SQL SubprogramsTriggers Tasks Tested Oracle Transparent Data EncryptionEncryptionTools Used to Move a TableSUBTYPESyntax for Recompiling Database ObjectImplicit Data Type ConversionNULL HandlingVariable VisibilityGOTO StatementSingle Cursor and Multiple Row TypeEmployee BonusCursor AttributesGroup FunctionsControl StructureCursor ExpressionsExtend the CollectionUsage of HintEfficient SQLValue Error ExceptionVariable Record LayoutPerformance AnalysisCommon ExceptionBitmap IndexBitmap Index RestrictionChoosing Collection TypesCompressed IndexAssociative ArraysVarray vs. Nested TableTransaction ControlPL/SQL Procedures and FunctionsArray HandlingPackage FunctionPackage OverloadingAdvantages of PL/SQL SubprogramsPL/SQL ParameterCaching Existing ResultCompound TriggerOrdering Trigger ExecutionTrigger Conditional ExecutionTrigger RestrictionTrigger Dependency
