1. Execute a single line and group functions for a table.
2. Execute DCL and TCL Commands.
3. Create and manipulate various DB objects for a table.
4. Create views – partitions and locks for a particular DB.
5. Write PL/SQL procedure for an application using exception handling.
6. Write PL/SQL procedure for an application using cursors.
7. Write a DBMS program to prepare reports for an application using functions.
8. Write a PL/SQL block for transaction operations of a typical application using
triggers.
9. Write a PL/SQL block for transaction operations of a typical application using
package.
10. Design and develop an application using any front end and back end tool (make
use of ER Diagram and DFD).
11. Develop an application using Menus
12. Importing / Exporting Data
13. Reports Creations Typical Applications – Banking – Electricity Billing
Library Operation – Pay roll – Insurance – Inventory – etc. |