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
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