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 Fundamentals

Description:

Our Oracle PL/SQL Fundamentals test measures your knowledge of database development using Oracle PL/SQL. This is based on knowledge through Oracle 11g. Designed for entry level programmers, this test focuses on the topics used daily by most professionals and does not include some of the advanced topics found in our Oracle PL/SQL test. The test includes the following topics: Data Manipulation Language, Database Management, Exceptions And Debugging, Language Elements, Packages, Performance And Tuning, Subprograms, and Transactions.

$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

Data Manipulation Language
Built-In Functions
Data Manipulation
Data Retrieval
Joins, Subqueries And Sets
Limiting And Sorting
Database Management
DDL
Dependencies
Privileges
Schema Manipulation
Exceptions And Debugging
Propogation
Throwing And Handling
Types
Language Elements
Collections
Flow Control
Lexical Rules
Loops
Variables, Data Types And Conversions
Packages
Creating And Managing
Invoking
Oracle-Supplied
Performance And Tuning
Caching
Deterministic Functions
Native Dyanamic SQL
Profiling And Tracing
Subprograms
Code Blocks
File System Access
Procedures And Functions
Triggers
Transactions
Controlling
Cursor Parameters
Explicit Cursors
Implicit Cursors