Oracle 11g Release 2 for Developers Assessment

  • $10.00


This Oracle 11g Release 2 for Developers assessment 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.

Number of questions 41
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Collection Types and Indexes
Cursors
Oracle11g Features
Performance Tuning
PL/SQL Subprograms
Triggers
Tasks tested Advantages of PL/SQL Subprograms
Array Handling
Associative Arrays
Bitmap Index
Bitmap Index Restriction
Caching Existing Result
Choosing Collection Types
Common Exception
Compound Trigger
Compressed Index
Control Structure
Cursor Attributes
Cursor Expressions
Efficient SQL
Employee Bonus
Encryption
Extend the Collection
GOTO Statement
Group Functions
Implicit Data Type Conversion
NULL Handling
Oracle Transparent Data Encryption
Ordering Trigger Execution
Package Function
Package Overloading
Performance Analysis
PL/SQL Parameter
PL/SQL Procedures and Functions
Single Cursor and Multiple Row Type
SUBTYPE
Syntax for Recompiling Database Object
Tools Used to Move a Table
Transaction Control
Trigger Conditional Execution
Trigger Dependency
Trigger Restriction
Usage of Hint
Value Error Exception
Variable Record Layout
Variable Visibility
Varray vs. Nested Table
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)