CS403 - Database Management Systems 

Finalterm Subjective Paper July 2012

• Write down the alternative name of browser base form? 2 marks
• Different classification of indexes? 2 Marks
• List down any two problems which may come up if the concurrency is not controlled properly? 2 marks
• In three schema architecture, External schema is responsible for data storage on hard disk. Correct and justify it. 3 marks
• Create view named “Product_list” on product table which will show all the columns? 3 marks
• Describe the importance of Data link properties tool in designing form by using MS Access? 3 marks
• In recovery procedure, transaction ended before the check points are redone. Correct it and justify? 3 marks
• Draw cross Reference matrix? 5 marks diagram was given.
• Deadlock is a serious threat for the concurrent transaction; shortly explain the approach which is used to detect the deadlock by DBMS? 5 marks
• Rehashing is better than chaining in term of time. (Rehashing and chaining collision resolution technique in hashing). Justify it ? 5 Marks