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 Systems Question Paper

Advanced Database Systems

Course:Bachelor Of Computer Science

Institution: Kenya Methodist University question papers

Exam Year:2013

KENYA METHODIST UNIVERSITY

END OF 3''RD ''TRIMESTER 2013 (FT) EXAMINATION
FACULTY : COMPUTING & 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.

Question One

Explain what you understand by the term concurrency control and outline its properties.

(5mks)

With the aid of a suitable example, describe the uncommitted dependency (dirty read) problem and recommend a solution.

(5mks)

Explain the term DDBMS and describe the motivations in providing such a system.

(5mks)

Explain the following terms in the context of a data warehouse

Subject-oriented

(2mks)

Integrated

(2mks)

Time-variant

(2mks)

Non-volatile

(2mks)

Identify the main issues associated with the development and management of data marts.

(7mks)

Question Two

List the security features of a DBMS.

(7mks)

Briefly explain the role of data mining in any business.

(5mks)

Describe three key features of 00DBMS

(3mks)

Question Three

(i) Explain how DBMS locks work.

(2mks)
ii) Distinguish between the various types of locks. (4mks)

Describe the relationship between data warehousing, data mining and online analytical processing (OLAP)

(5mks)

Explain with justification why a multi-user DBMS should provide a recovery mechanism.

(4mks)

Question Four

(i) What is the difference between a homogenous and heterogeneous DDBMS.

(2mks)
ii) Under what circumstances would such systems arise? (3mks)

Outline only five of data’s twelve rules for a DDBMS.

(5mks)

Differentiate between a shared and an exclusive lock and give three examples depicting how they are used.

(5mks)

Advanced Database Systems Question Paper

More Question Papers

Popular Exams