Oracle 11g Release 2 for Developers Assessment

$16.00

Oracle 11g Release 2 for Developers Assessment

$16.00
description

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.

 

Number of questions 41
Competencies tested Oracle11g Features
Cursors
Performance Tuning
Collection Types and Indexes
PL/SQL Subprograms
Triggers
Tasks tested Oracle Transparent Data Encryption
Encryption
Tools Used to Move a Table
SUBTYPE
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