MC9218 DBMS Lab lab manual download for MCA

1 To create a table and then perform Insertion, Deletion and Updating and then execute single line and group line functions.

To create a table and execute the TCL and DCL commands.


To create a table and to manipulate various database objects.

To create a table and create locks, partitions for the particular database.

To write a PL/SQL procedure for an application using user-defined and predefined exceptions.

To write a PL/SQL program for an application using cursor.


To create a program to prepare reports for an application using functions.

 
To create a PL/SQL block for transaction applications of a typical application using triggers.

To create a PL/SQL block for transaction applications of a typical application using Packages.

 
To create an employee application using VB as front end and Oracle as backend.


Click Here To Download MC9218 manual