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

Cisy 423:Advanced Database Managment Systems Question Paper

Cisy 423:Advanced Database Managment Systems

Course:Computer Science

Institution: Kenya Methodist University question papers

Exam Year:2013

KENYA METHODIST UNIVERSITY

END OF 3''RD ''TRIMESTER 2013 (PT) EXAMINATION
FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : COMPUTER SCIENCE AND BUSINESS INFORMATION
UNIT CODE : CISY 423/BBIT 423
UNIT TITLE : AVANCED DATABASE MANAGEMENT SYSTEMS
TIME : 2 HOURS

Instructions: Answer all questions in section A and two question in section B.

Section A

Question one

Define the following terms.

(8mks)

Query optimization
Interleaved execution
Pipelining
Serial scheduling
What are the basic algorithms for executing query operations?(3mks)

List the advantagesof having distributed database.

(2mks)

In the context of database security, discuss the two main approaches for access control i.e discretionary access control and mandatory access control.

(4mks)

Explain two phase locking.

(3mks)

What is meant by crush recovery facility.

(2mks)

What are the functionalities of data mining system.

(4mks)

What are the benefits and costs of using indexes.

(4mks)

SECTION B

Question Two

With examples describe the following anomalies.

(12mks)

Write-Read Conflicts (WR conflict)
Read –Write (RW Conflicts)
Write –Write conflicts (WW conflicts)

List the advantagesof having distributed database.

(4mks)

What are the methods of prevent unauthorized users in remote accessing in distributed database.

(4mks)

Question Three

LECTURE (1-no, Iname, status)

UNIT (U-no, d-no, uname)

DEPARTMENT (d-no, dname, hod)

STUDENT (s-no snamesaddress)

ASSESSMENT (s-no, u-no, final-grade)

TIMETABLE (u-no, session-no, I-no, code)

From the schema above generate SQL that will meet the following conditions.

List the student number and unit number for those students who have passed these units with a final grade greater than 4.

(4mks)

Find the number of students who have achieved one or more final grades greater than 14

(5mks)

Using the table LECTURER illustrate the concept of entity integrity and possible constraints.

(5mks)

Show muprivy of relation of all tables.

(6mks)

Question Four

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

(10mks)

Deferred update
Immediate update
Shadow paging
Aries algorithm has three main principles. Explain each of them. (10mks)
Write-ahead logging
Repeat history during redo
Logging chances during undo.

Cisy 423:Advanced Database Managment Systems Question Paper

More Question Papers

Popular Exams