ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

Oracle PL/SQL Fundamentals Test

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.



Scope of the online Oracle PL/SQL Fundamentals Test

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

Duration

40 minutes.

Assessment Method of Questions

Multiple choice questions

Each question has between 2 and 8 options out of which 1 or more may be correct.

More links

Related Professions

Web Developer (BCIP), Database Administrator, Software Quality Analyst

Keywords

oracle sql fundamentals certification, oracle pl/sql fundamentals test