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 |