Get premium membership and access revision papers, questions with answers as well as video lessons.

Advanced Database Management System(Bbit 432) (Cisy 423) Question Paper

Advanced Database Management System(Bbit 432) (Cisy 423)

Course:Computer Science & Business Information

Institution: Kenya Methodist University question papers

Exam Year:2012

UNIT CODE : BBIT 432/423
UNIT TITLE : ADVANCED DATABASE MANAGEMENT SYSTEMS
TIME : 2 HOURS

SECTION A: ANSWER ALL (30 Marks)
Question One
Define the following terms. (8 Marks)
Partial Transaction
Data Mining
RAID
Durability

Question Two
List FOUR common types of database failure. (4 Marks)

Question Three
What is meant by crash recovery. (2 Marks)

Question Four
What are the benefits and cost of using indexes. (3 Marks)

Question Five
What are the needs of data warehousing in an organization. (4 Marks)

Question Six
List the main advantages of having a distributed database. (4 Marks)

Question Seven
What are the methods used to prevent unauthorized users in remote from accessing distributed database. (3 Marks)

Question Eight
List the various types of database anomalies. (2 Marks)

Question Nine
Explain the concept of ARIES Algorithm. (3 Marks)

SECTION B: Answer any TWO Questions.
Question One
Describe the following deadlock mechanisms.
(10 Marks)
Deadlock prevention
Deadlock Avoidance
Deadlock detection
Find out whether the following system is in Deadlock or NOT (Show your argument.)
Total number of processes 3 (P1, P2, P3)
Total number of resources 3 (R1, R2, R3)
P1 holds R1 and waiting for R2
P2 holds R2 and waiting for R3
P3 holds nothing and waiting for R3
(5 Marks)

Question Two
Describe index file organization and its benefits.
(12 Marks)
Describe the factors to be considered in selecting Data Storage Devices.
(3 Marks)

Question Three
What are the main challenges of distributed databases.
(5 Marks)

Describe RAID Technology, in Raid) and Raid I explains advantages & disadvantages of each.
(10 Marks)

Advanced Database Management System(Bbit 432) (Cisy 423) Question Paper

More Question Papers

Popular Exams