1.
a) Creation, altering and dropping of tables and insert, delete, update and select 5 rows into
a table (use constraints while creating tables) examples using SELECT command.
b) Develop Programs using BEFORE and AFTER Triggers, Row and Statement Triggers and
INSTEAD OF Triggers
2. Queries (along with sub Queries) using ANY, ALL, IN, EXISTS, NOTEXISTS, UNION,
INTERSECT, Constraints.
3. a) Queries using Aggregate functions, GROUP BY, HAVING and Creation and Dropping
of Views.
b) Programs development using creation of procedures, passing parameters IN and OUT of
PROCEDURES.
4. a) Queries using Conversion functions, String functions, Date functions.
b) Program development using creation of stored functions, invoke functions in SQL
Statements and write complex functions.
5. i) Creation of simple PL/SQL program which includes declaration section, executable
section and exception –handling
ii) Insert data into student table and use COMMIT, ROLLBACK and SAVEPOINT in
PL/SQL
6. Develop a program that includes the features NESTED IF, CASE and CASE expression.
The program can be extended using the NULLIF and COALESCE functions.
7. Program development using WHILE LOOPS, numeric FOR LOOPS, nested loops using
ERROR Handling, BUILT –IN Exceptions, USE defined Exceptions, RAISE-
APPLICATION ERROR.
8. a) Programs development using creation of procedures, passing parameters IN and OUT of
PROCEDURES.
b) Queries using Conversion functions, String functions.
9. a) Program development using creation of stored functions, invoke functions in SQL
Statements and write complex functions.
b) Creation, altering and dropping of tables and insert, delete, update and select 5 rows into
a table (use constraints while creating tables) examples using SELECT command.
10. Program development using creation of package specification, package bodies, private
objects, package variables and cursors and calling stored packages.
11) a) Develop programs using features parameters in a CURSOR, FOR UPDATE CURSOR,
WHERE CURRENT of clause and CURSOR variables.
b) Creation, altering and dropping of tables and insert, delete, update and select 10 rows
into a table (use constraints while creating tables) examples using SELECT command.
12) a) Develop Programs using BEFORE and AFTER Triggers, Row and Statement Triggers
and INSTEAD OF Triggers
b) Queries using Conversion functions, Date functions.
