Oracle 11g Release 2 for Developers Assessment


Oracle 11g Release 2 for Developers Assessment

Skills Assessment

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.


What Am I Buying?
When you purchase an assessment with Talevation, you will receive a credit for our online assessment portal. To access your purchase, you must head to our Login page found in the top right corner. There, you may redeem your credit and generate a link which will be sent to the candidate of your choosing.

How does it work?
Total Questions 41
Question Types Multiple Choice
Competencies Tested Oracle11g Features
Performance Tuning
Collection Types and Indexes
PL/SQL Subprograms
Tasks Tested Oracle Transparent Data Encryption
Tools Used to Move a Table
Syntax for Recompiling Database Object
Implicit Data Type Conversion
NULL Handling
Variable Visibility
GOTO Statement
Single Cursor and Multiple Row Type
Employee Bonus
Cursor Attributes
Group Functions
Control Structure
Cursor Expressions
Extend the Collection
Usage of Hint
Efficient SQL
Value Error Exception
Variable Record Layout
Performance Analysis
Common Exception
Bitmap Index
Bitmap Index Restriction
Choosing Collection Types
Compressed Index
Associative Arrays
Varray vs. Nested Table
Transaction Control
PL/SQL Procedures and Functions
Array Handling
Package Function
Package Overloading
Advantages of PL/SQL Subprograms
PL/SQL Parameter
Caching Existing Result
Compound Trigger
Ordering Trigger Execution
Trigger Conditional Execution
Trigger Restriction
Trigger Dependency