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 |