PL/SQL Assessment
$16.00
PL/SQL Assessment
$16.00
Number of questions | 40 |
Competencies tested | Basic Syntax Procedures and Functions Packages Advanced Features Triggers |
Tasks tested | Autonomous Transactions Functions Block Structure Dynamic SQL Execution FOR Loop Retrieve Rows from a Cursor Variable Names FOR Loop Syntax Boolean Conditions Trapping Exceptions DBMS_SQL Package Block Syntax ROWTYPE Attribute Overloading Feature Anonymous Blocks Parameter Mode Default Value Invoke a Function SQL Statement Function Call Formal Parameter Intact Function Privileges Create Functions Object Must Return Values Data Dictionary Views Create Stored Procedures Parameter Mode Create Packages PL/SQL Package Specification PL/SQL Packages Oracle-Supplied Packages Package Body Variable Types Clause to Return Same Result Value Keyword to Bind Array of Values PL/SQL Function Result Cache Fast Compiler Settings Defined Object Trigger Compound Triggers Triggers Timing Privileges for Database Trigger Creation Recompile Triggers Create Triggers |