Oracle PL/SQL

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

 

Go Back