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

Cisy 423:Advanced Database Management Question Paper

Cisy 423:Advanced Database Management

Course:Computer Science

Institution: Kenya Methodist University question papers

Exam Year:2012

KENYA METHODIST UNIVERSITY

END OF 3''RD ''TRIMESTER 2012 (DAY) EXAMINATIONS
FACULTY : COMPUTING AND INFORMATICS
DEPARTMENT : COMPUTER SCIENCE AND BUSINESS
INFORMATION
UNIT CODE : CISY 423/BBIT 432
UNIT TITLE : ADVANCED DATABASE MANAGEMENT
TIME : 2 HOURS

Instructions:

Answer question one and any other two questions.

Question One
1. Define the following terms. (8 marks)

Query optimization
Interleaved execution
Pipelining
Isolation

2. What are the functionalities of data mining system? (4 marks)
3. List four common types of data failures. (4 marks)
4. What are the Basic Algoriths for executing query operations? (4 marks)
5. What are the methods to prevent unauthorized users in remote accessing in distributed database? (3 marks)
6. List the advantages of having distributed database. (2 marks)
7. What is meant by crash recovery? (2 marks)
8. What are the benefits and costs of using indexes? (3 marks)

SECTION B

Question Two

With examples describe the following anomalies.

(12 marks)

Write-Read conflicts (WR conflicts)
Read-Write conflicts (RW conflicts)
Write-Write conflicts (WW conflicts)

Describe locking protocols.

(8 marks)

Question Three

Describe RAID Technology.

(10 marks)

Distinguish between logical and physical security of the database.

(5 marks)

Find out whether the following system is Deadlock or not (show your argument)

(5 marks)

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

Question Four

Describe the following three main recovery techniques that are commonly employed are:

(10 marks)

1. Deferred Update

2. Immediate Update

3. Shadow paging

Explain the following three main principles of ARIES algorithm.

(10 marks)

1. Write-ahead logging

2. Repeating history during redo

3. Logging changes during undo

Cisy 423:Advanced Database Management Question Paper

More Question Papers

Popular Exams