LIST OF PRACTICALS
| Sr. | Practical Title | Answer |
|---|---|---|
| 1 | Creating and Manipulating Database objects and Applying Constraints (DDL) | Solution |
| 2 | Manipulating Data with Database Objects (DML) | Solution |
| 3 | Retrieving, Restricting and Sorting Data (DRL) | Solution |
| 4 | SQL Single Row Functions | Solution |
| 5 | SQL Multiple Row Functions (Aggregate Function) | Solution |
| 6 | Displaying Data from Multiple Tables (Join) | Solution |
| 7 | Using Commit and Rollback show Transaction ACID Property | Solution |
| 8 | Securing data using Views and Controlling User Access (DCL) | Solution |
| 9 | PL/SQL Block Syntax and DML Operation through PL/SQL Block | Solution |
| 10 | Control Structures in PL/SQL | Solution |
| 11 | Working with Cursor | Solution |
| 12 | Creating Procedures and Functions in PL/SQL | Solution |
| 13 | Creating Database Triggers | Solution |
| 14 | Design Database Management System with all the required documentation and specification | Solution |
| 15 | Solution |
0 Comments