What is the purpose of IN Fucntions? In which situation join is used? What is serial execution? Write three advantages of views? What are locking protocols, explain? What is rehashing? In which situation self join is used? Why direct access is preferred over sequential access?
................
Another Paper:
1.Application programmer as user of database systems, (5) 2.different b/w rollback and rollforward.(5) 3.why will you prefer delete command on drop command while deleting a table,(5) 4.how many number of clusters are used in database and reason of limit, 5.purpose of having clause, 6.purpose of protection, 7.explain data independency 8.two types of interface, 9.write DML statement that changes the values of one or more than one attribute based on some condition. 10.describe insertion anomaly, 11.COMMIT and ROLLBACK
