DBMS Exercise - I
1) Create a table STUDENT with appropriate data types and perform the following queries. Attributes are Roll number, student name, date of birth, branch and year of study . a) Insert 5 to 10 rows in a table? b) List all the students of all branches. c) List student names whose name starts with ‘s‘. d) List student names whose name contains ‘s as third literal. e) List student names whose contains two ‘s‘ anywhere in the name f) List students whose branch is NULL. g) List students of CSE & ECE who born after 1980. h) List all students in reverse order of their names. i) Delete students of any branch whose name starts with ‘s‘. j) Update the branch of CSE students to ECE. k) Display student name padded with *‘after the name of all the students.