Page 292 - aREA ix eXHIBITS

EVIDENCE GUIDE

1. Critical Aspect of 1.1 Created and debug stored procedures and functions
Competency 1.2 Used conditional compilation to customize the functionality
in a PL/SQL application without removing any source code
1.3 Designed PL/SQL packages to group related constructs
1.4 Created overloaded package subprograms for more
flexibility
1.5 Designed PL/SQL anonymous blocks that execute
efficiently
2. Underpinning 2.1 Conditionally control code flow (loops, control structures).
Knowledge 2.2 Use PL/SQL packages to group and contain related
constructs.
2.3 Generate triggers to solve business challenges.
2.4 Create anonymous PL/SQL blocks, as well as stored
procedures and functions.
2.5 Use some of the Oracle supplied PL/SQL packages to
generate screen output and file output.
2.7 Create anonymous PL/SQL blocks, functions and
procedures.
3. Underpinning Skills 3.1 Basic computer operation skills
3.2 Logic analysis
3.3 Communication skills
3.4 Code writing and debugging skills
4. Method of The assessor will assess candidate with-
Assessment
4.1 Portfolio
• Result of Oracle Vendor Examinations
• Sample codes
4.2 Interview
5. Resource 5.1 Computer hardware with peripherals
Implication 5.2 Appropriate software
5.3 Access to internet
5.4 Conducive testing environment
6. Context of Assessment may take place in an accredited Oracle testing
Assessment center

_________________________________________________________________________________ 37
TR – Programming (Oracle Database) NC III Promulgated – December 2013