CS403 Database Management Systems All Current Final Term Papers at One Place From 20 Feburary to 03 March Fall 2012

Q1: write down the alternative name of browser base form? 2 marks

Q2: Different classification of indexes? 2 Marks

Q3: List down any two problems which may come up if the concurrency is not controlled properly? 2 marks ( handout page 307)

Q4: In three schema architecture, External schema is responsible for data storage on hard disk. Correct and justify it. 3 marks

Q5: Create view named “Product_list” on product table which will show all the columns? 3 marks

Sponsored Links

Q6: Describe the importance of Data link properties tool in designing form by using MS Access? 3 marks

Q7: In recovery procedure, transaction ended before the check points are redone. Correct it and justify? 3 marks

Q8: Draw cross Reference matrix? 5 marks diagram was given

Q9: Deadlock is a serious threat for the concurrent transaction; shortly explain the approach which is used to detect the deadlock by DBMS? 5 marks

Q10: Rehashing is better than chaining in term of time. (Rehashing and chaining collision resolution technique in hashing). Justify it ? 5 Marks