CS403 Final Term Subjective Paper July 2013

CS403 - Database Management Systems Final term Subjective Paper July-2013

Q1. Difference between exhaustive and partial indexes.(Marks:2)

Q2. Types/categories of indexes.(Marks:2)

Q3. Hashing is not working in collision , compare good, average, worst with linear probing, chaining and rehashing .(page=269).(Marks:3)

Q4. Compare statements against RAID00 to RAID5 (page 258-259). (Marks:5)

Statement were like, I/O operation not supported, Write not supported, 3 or more disks required, fault not recovered, if disks 3 or more then this RAID is useless etc.

Q5. How external level schema helps different users according to their needs.(Marks:5)

Q6. Statement about durability and atomicity were give, justify correct or not with explanation.(Marks:5)

Q7. Table given and write SQL statement for VIEW an attribute from table were city Gujranwala.(Marks:5)

Q8. Table is given, which normal form is it and why.(Marks:3)

Print to PDF without this message by purchasing novaPDF ( )