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!

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)

Cisy 423:Advanced Database Systems Question Paper

More Question Papers

Popular Exams