Page 299 - aREA ix eXHIBITS

CORE COMPETENCIES
160 hrs.

Assessment
Unit of Competency Learning Outcome Methodology
Approach
1. Perform relational 1.1 Retrieve Data Using the  Lecture/  Practical exam
database SQL SELECT Statement Discussion  Interviews/
management in 1.2 Use Single-Row  Hands on questioning
Oracle database Functions to Customize  Exercises
technology Output  Demonstration
1.3 Display Data From
Multiple Tables Using
Joins
1.4 Manipulate Data
1.5 Control User Access
1.6 Manipulate Large Data
Sets
1.7 Manage Data in Different
Time Zones
1.8 Retrieve Data Using
Sub-queries

2. Use and apply 2.1 Declare PL/SQL  Lecture/  Practical exam
PL/SQL Identifiers Discussion  Interviews/
Programming 2.2 Apply Interaction with  Hands on questioning
Language the Oracle Server  Exercises
2.3 Apply Exception  Demonstration
Handling
2.4 Store Procedures

3. Design and tune 3.1 Design PL/SQL Code  Lecture/  Practical exam
PL/SQL Language 3.2 Use advanced interface Discussion  Interviews/
methods  Hands on questioning
3.3 Apply performance and  Exercises
tuning to PL/SQL code  Demonstration
3.4 Implement virtual private
database with fine-
gained access control

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