| 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 |
