📘 Access 10,000+ CBC Exams With Marking Schemes

Prepare your learners for success! Get CBC-aligned exams for Grades 1–9, PP1–PP2, Playgroup and High School - all with marking schemes.

Browse Exams

Instant download • Trusted by 100,000+ teachers • Updated weekly

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


Exams With Marking Schemes

End Term 3 Exams

Mid Term Exams

End Term 1 Exams

Opener Exams

Full Set Exams



Return to Question Papers