Cisy 423:Advanced Database Systems Question Paper
Cisy 423:Advanced Database Systems
Course:Computer Science
Institution: Kenya Methodist University question papers
Exam Year:2012
KENYA METHODIST UNIVERSITY
END OF 2''ND ''TRIMESTER 2012 (DAY) EXAMINATIONS
FACULTY : COMPUTING AND INFORMATICS
DEPARTMENT : COMPUTER SCIENCE AND BUSINESS INFORMATION
UNIT CODE : CISY 423/BBIT 432
UNIT TITLE : ADVANCED DATABASE SYSTEMS
TIME : 2 HOURS
Instructions:
Answer question one and any other two questions
Question One
List and briefly explain the security features of a DBMS
( 7mks)
Explain how DBMS locks work and distinguish between the various types of locks.
(4mks)
Briefly describe the relations between data ware housing, data mining and online analytical processing.
(4mks)
Explain the concept of transparency in distributed databases and describe how it can be implemented.
(5mks)
Compare relational data bases and multidimensional databases. (4mks)
List and explain three strategies for building an OODBMS.
(6mks)
Question Two
Explain the concept of replication and distinguish between vertical and horizontal fragmentation.
(4mks)
Describe four key features of OODBMS.
(4mks)
Briefly explain the role of data mining in business.
(7mks)
Question Three
Explain the key issues to be considered when building a data warehouse.
(5mks)
i) Describe concurrency control.
(2mks)
ii) Explain the properties of concurrency control. (3mks)
Briefly describe the uncommitted dependency problem and explain how it can be solved.
(5mks)
Question Four
Giving a suitable example, describe the role of the system catalogue in transactions management.
(6mks)
Outline the OODBMS manifesto.
(4mks)
Describe various database integrity features implemented in a DBMS you are familiar with.
(5mks)
More Question Papers
Exams With Marking Schemes
Popular Exams
Mid Term Exams
End Term 1 Exams
End Term 3 Exams
Opener Exams
Full Set Exams
Return to Question Papers