KABARAK UNIVERSITY
UNIVERSITY EXAMINATIONS
FIRST SEMESTER ACADEMIC YEAR 2020/2021
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE
INFORMATION TECHNOLOGY/BACHELOR OF BUSINESS MANAGEMENT
INFORMATION TECHNOLOGY
INTE 214: ADVANCED DATABASE MANAGEMENT
SYSTEM
STREAM: Y3S1 TIME: 2:00-4:00 PM
EXAMINATION SESSION: SEPT-DEC DATE:03/02/2021
INSTRUCTIONS TO CANDIDATES
1. Answer Question 1 and any other two questions in the answer booklet provided.
2. Do not write on your question papers. All rough work should be done in your
answer booklet.
3. Clearly indicate which question you are answering.
4. Write neatly and legibly.
5. Follow all the instructions in the answer booklet
As members of Kabarak University family, we purpose at all times and in all places, to set apart in one’s heart,
Jesus as Lord. (1 Peter 3:15)
Kabarak University is ISO 9001:2015 Certified
Page 1 of 5
, SECTION A: (COMPULSORY) TOTAL MARKS FOR THIS SECTION IS 30.
QUESTION ONE
a. Discuss using suitable examples how the following are achieved
Horizontal fragmentation (3 Marks)
Vertical fragmentation (3 Marks)
b. Write a PLSQL block to calculate the interest paid of a loan of ksh. 20,000 for a period of 3
years with a monthly payment of ksh.600 formula is I/PT=R (4 Marks)
c. During the redo phase, it is possible to encounter an update log record for page P when P is
not in the dirty page table (true or false) explain your answer (2 Marks)
d. Describe each of the following terms as used in database management
i. Domain relational calculus (2 Marks)
ii. Relational Algebra (2 Marks)
iii. Query optimizer (2 Marks)
e. Discuss the methods available in modern database systems to maintain concurrency control.
(4
Marks)
f. By first outlining the procedure, test whether the following schedules are conflict serializable
i.) Read_Item(T1, X), Read_Item (T2, X), Write_Item (T1, X)
Write_Item (T2, X), Commit (T1), Commit (T2) (4 Marks)
ii.) Read_Item (T1, X), Write_Item (T1, X), Read_Item (T2, X)
Write_Item (T2, X), Commit (Ti), Commit (T2) (4 Marks)
As members of Kabarak University family, we purpose at all times and in all places, to set apart in one’s heart,
Jesus as Lord. (1 Peter 3:15)
Kabarak University is ISO 9001:2015 Certified
Page 2 of 5
UNIVERSITY EXAMINATIONS
FIRST SEMESTER ACADEMIC YEAR 2020/2021
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE
INFORMATION TECHNOLOGY/BACHELOR OF BUSINESS MANAGEMENT
INFORMATION TECHNOLOGY
INTE 214: ADVANCED DATABASE MANAGEMENT
SYSTEM
STREAM: Y3S1 TIME: 2:00-4:00 PM
EXAMINATION SESSION: SEPT-DEC DATE:03/02/2021
INSTRUCTIONS TO CANDIDATES
1. Answer Question 1 and any other two questions in the answer booklet provided.
2. Do not write on your question papers. All rough work should be done in your
answer booklet.
3. Clearly indicate which question you are answering.
4. Write neatly and legibly.
5. Follow all the instructions in the answer booklet
As members of Kabarak University family, we purpose at all times and in all places, to set apart in one’s heart,
Jesus as Lord. (1 Peter 3:15)
Kabarak University is ISO 9001:2015 Certified
Page 1 of 5
, SECTION A: (COMPULSORY) TOTAL MARKS FOR THIS SECTION IS 30.
QUESTION ONE
a. Discuss using suitable examples how the following are achieved
Horizontal fragmentation (3 Marks)
Vertical fragmentation (3 Marks)
b. Write a PLSQL block to calculate the interest paid of a loan of ksh. 20,000 for a period of 3
years with a monthly payment of ksh.600 formula is I/PT=R (4 Marks)
c. During the redo phase, it is possible to encounter an update log record for page P when P is
not in the dirty page table (true or false) explain your answer (2 Marks)
d. Describe each of the following terms as used in database management
i. Domain relational calculus (2 Marks)
ii. Relational Algebra (2 Marks)
iii. Query optimizer (2 Marks)
e. Discuss the methods available in modern database systems to maintain concurrency control.
(4
Marks)
f. By first outlining the procedure, test whether the following schedules are conflict serializable
i.) Read_Item(T1, X), Read_Item (T2, X), Write_Item (T1, X)
Write_Item (T2, X), Commit (T1), Commit (T2) (4 Marks)
ii.) Read_Item (T1, X), Write_Item (T1, X), Read_Item (T2, X)
Write_Item (T2, X), Commit (Ti), Commit (T2) (4 Marks)
As members of Kabarak University family, we purpose at all times and in all places, to set apart in one’s heart,
Jesus as Lord. (1 Peter 3:15)
Kabarak University is ISO 9001:2015 Certified
Page 2 of 5
