Page 296 - aREA ix eXHIBITS

EVIDENCE GUIDE

1. Critical Aspect of Assessment requires evidence that the candidate:
Competency
1.1 Designed PL/SQL packages and program units that
execute efficiently
1.2 Wrote code to interface with external applications and
the operating system

1.3 Created PL/SQL applications that use collections
1.4 Wrote and tuned PL/SQL code effectively to maximize
performance

1.5 Implemented virtual private database with fine-grained
access control

2.Underpinning 2.1 PL/SQL designing best practices.
Knowledge 2.2 Create PL/SQL applications that use collections.
2.3 Implement a virtual private database with fine-grained
access control.
2.4 Write code to interface with external C and Java
applications.
2.5 Write code to interface with large objects and use
SecureFile LOBs.
2.6 Write and tune PL/SQL code effectively to maximize
performance
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 Assessment The assessor will assess candidate with-
4.1 Portfolio
• Result of Oracle Vendor Examinations
• Sample codes
4.2 Interview
5.Resource Implication • Computer hardware with peripherals
• Appropriate software
• Access to internet
• Conducive testing environment
6.Context of Assessment may take place in an accredited Oracle testing
Assessment center

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