Consider the following schema and write SQL query for given statements.
Student ( regNo, sName, sCity, sCGPA, sAge)Course ( cCode, cName, credit_hours)Enrollment (regNo, cCode, semester,quality_points,Grade)
1- Display 2nd row of Student table using Cursors.
2- Display all records of Enrollment table which are placed at even rows.
3- Execute given query in SQL and do as directed.a) UPDATE STUDENT SET ECITY = ‘ISB’ WHERE EID>101b) Count how many records have been updated in above query using cursor.
4- Write a mechanism which must not allow user to delete more than 1 records using cursor and transaction.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here