DBMS Practical Solution GTU

LIST OF PRACTICALS

Sr PRACTICAL TITLE ANSWER
1 To study DDL-create and DML-insert commands Solution
2 Create table and insert sample data in tables Solution
3 Perform queries involving predicates LIKE, BETWEEN, IN etc. Solution
4 To Perform various data manipulation commands, aggregate functions and sorting concept on all created tables. Solution
5 To study Single-row functions. Solution
6 Displaying data from Multiple Tables (join) Solution
7 To apply the concept of Aggregating Data using Group functions. Solution
8 To solve queries using the concept of sub query. Solution
9 To apply the concept of security and privileges Solution
10 To study Transaction control commands Solution
11 Write Cursor Solution
12 Write Trigger Solution