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