PL/SQL Assessment

  • $10.00

This PL/SQL assessment is designed to assess the knowledge of assessment takers concerning the use of PL/SQL. The topics covered include basic syntax, procedures and functions, packages, advanced features, and triggers. It is appropriate to administer this assessment to assessment takers who have used PL/SQL for a year or more.

Number of questions 40
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Advanced Features
Basic Syntax
Procedures and Functions
Tasks tested Anonymous Blocks
Autonomous Transactions
Block Structure
Block Syntax
Boolean Conditions
Clause to Return Same Result Value
Compound Triggers
Create Functions
Create Packages
Create Stored Procedures
Create Triggers
Data Dictionary Views
DBMS_SQL Package
Defined Object Trigger
Dynamic SQL Execution
Fast Compiler Settings
FOR Loop
FOR Loop Syntax
Formal Parameter
Intact Function Privileges
Invoke a Function
Keyword to Bind Array of Values
Object Must Return Values
Oracle-Supplied Packages
Overloading Feature
Package Body Variable Types
Parameter Mode
Parameter Mode Default Value
PL/SQL Function Result Cache
PL/SQL Package Specification
PL/SQL Packages
Privileges for Database Trigger Creation
Recompile Triggers
Retrieve Rows from a Cursor
ROWTYPE Attribute
SQL Statement Function Call
Trapping Exceptions
Triggers Timing
Variable Names
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)