CS403 Final Term Current Paper (Feb 2011)
Friday, February 11, 2011 Posted In .Final Term Exam (Feb 2011) Edit This
CS403 Final Term Current Paper (Feb 2011)
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?
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
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
