Page 293 - aREA ix eXHIBITS

UNIT OF COMPETENCY: DESIGN AND TUNE PL/SQL LANGUAGE
UNIT CODE : ICT313364

UNIT DESCRIPTOR : This unit covers the advanced features of PL/SQL to design
and tune PL/SQL. It also covers how to manage PL/SQL to
interface with the database and other applications in the
most efficient manner

ELEMENT PERFORMANCE CRITERIA
Italicized terms are elaborated in the Range of Variables
1 Design PL/SQL Code 1.1 Predefined data types are described in accordance
with PL/SQL framework
1.2 Subtypes based on existing types for an application
are created in accordance with PL/SQL framework
1.3 Different guidelines for cursor design are listed in
accordance with PL/SQL framework
1.4 Collections are used in accordance with PL/SQL
framework
1.5 Manipulating Large Objects are manipulated in
accordance with PL/SQL framework

2. Use Advanced Interface 2.1 External Procedures from PL/SQL are called in
Methods accordance with PL/SQL framework
2.2 Benefits of External Procedures are listed in
accordance with PL/SQL framework
2.3 C advanced interface methods are shown in
accordance with PL/SQL framework
2.4 Java advanced interface methods are shown in
accordance with PL/SQL framework
3. Apply Performance and 3.1 The compiler is understood and influenced in
Tuning to PL/SQL code accordance with PL/SQL framework
3.2 PL/SQL code is tuned in accordance with PL/SQL
framework
3.3 Intra unit in-lining is enabled in accordance with
PL/SQL framework
3.4 Memory issues are identified and tuned in accordance
with PL/SQL framework
3.5 Network issues are recognized in accordance with
PL/SQL framework
3.6 Performance with Caching is improved in
accordance with PL/SQL framework

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