Get premium membership and access revision papers, questions with answers as well as video lessons.
Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Advanced Database Management Systems Question Paper

Advanced Database Management Systems 

Course:Bachelor Of Science In Computer Information Systems

Institution: Kenya Methodist University question papers

Exam Year:2012




KENYA METHODIST UNIVERSITY
CISY 423/ BBIT 432 ADVANCED DATATABASE MANAGEMENT SYSTEMS
3rdTrimester 2012
Section A
1. Define the term deadlock and outline the two main methods of dealing with a
deadlock problem. (3 marks)
2. Why are I/O costs important in a DBMS ( 2 marks)
3. If a DBMS already supports discretionary and mandatory access controls, is there a
need for encryption? (3 marks)
4. Describe pipelining and its advantages ( 4 marks)
5. Describe concept of ACID
6. Define the term deadlock and outline the two main methods of dealing with a
deadlock problem. (3 marks)
7. Why are I/O costs important in a DBMS ( 2 marks)
8. If a DBMS already supports discretionary and mandatory access controls, is there a
need for encryption? (3 marks)
9. Describe pipelining and its advantages ( 4 marks)
10. Briefly describe data mining and data warehouse architecture s ( 8 Marks)
Section B
2
1. Describe deadlock mechanisms ( 10 Marks )
2. Explain the benefits and the main functionalities of OODBMS ( 10 Marks
3. Describe RAID Technology Level 2 and 5 ( 10 Marks)
4. Describe ARIES Algorithm ( 10 Marks )






More Question Papers


Popular Exams



Return to Question Papers