LIST OF EXPERIMENTS
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).
(Typical Applications - Banking, Electricity Billing, Library Operation, Pay roll, Insurance,
Inventory, etc.)