Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

Oracle PL/SQL

Description:

Our Oracle PL/SQL test measures knowledge of database development using Oracle PL/SQL, based on knowledge through Oracle 11g. Designed for experienced programmers, this test covers the following topics: Architecture, Built-in Packages, DML and Transaction Management, Debugging, Exception Handling, Language Elements, Subprograms, Tuning, and Utilities.

This test is associated with a Job Role. Please visit the Job Role Center for more details.

Sample Test
$49.95

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Architecture
Memory Architecture
Physical File Structures
Server Processes
Built-in Packages
DBMS_OUTPUT
DBMS_SCHEDULER
DBMS_SESSION
UTL_FILE
Debugging
Display Debug Information
Profiling Code
Tracing Code
DML and Transaction Management
Cursors and Cursor Attributes
DML
Dynamic SQL
Transactions
Exception Handling
Exception Propagation
Oracle-specific Exception Handling Techniques
Raising Exceptions
Language Elements
Collections
Control Structures
Datatypes
Handling NULLs
Implicit and Explicit Conversion
Subprograms
Internal SQL Functions
Packages
Procedures
Triggers
User-Defined Functions
Tuning
Detection of Bottlenecks
Global Temporary Tables
Indexes and Partitions
Joins
Materialized Views
Utilities
Export Data
Import Data
Scripting