Inte 214: Advanced Database Management System Question Paper

Inte 214: Advanced Database Management System

Course:Bachelor Of Science In Information Technology

Institution: Kabarak University question papers

Exam Year:2013

KABARAK UNIVERSITY
UNIVERSITY EXAMINATIONS
2012/2013 ACADEMIC YEAR
FOR THE DEGREE OF BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY
(MC, TC)
INTE 214: ADVANCED DATABASE MANAGEMENT SYSTEM
DAY: THURSDAY

DATE: 5/12/2013
TIME: 8.30 – 10.30 A.M.
STREAM: Y2S1

Instructions:
•
Question One is compulsory from section A.
•
Choose other two questions and attempt from section B.

SECTION A (30 Marks)

Question One:
a) Explain the difference between logical and physical database design and why these tasks might be
carried out by different people?

(5 Marks)
b) Describe the access control facilities of SQL.

(4 Marks)
c) Explain in details the role of % type attribute and its two benefits with an example.

(4 Marks)
d) Briefly explain the four physical structures of the database.

(8 Marks)
e) Write a PLSQL block and display department_name, location for department_id 20 from the
departments table. (Use %type attribute)

(4 Marks)
f) Define the following:

i.
Exclusive lock

(1 Mark)
ii.
Schema

(1 Mark)
iii.
Query optimization

(1 Mark)
iv.
Deadlock

(1 Mark)
v.
Distributed DBMS

(1 Mark)

SECTION B: (20 MARKS EACH)

Question Two: (20 Marks)
a) Describe any three types of indexes.

(6 Marks)
b) Explain the relationship between the following:
i.
Database writer and data files

(2 Marks)
ii.
Log writer and redo log files

(2 Marks)
iii.
Checkpoint and control files

(2 Marks)
c) Explain the ‘if – then – elsif’.

(4 Marks)
d) Explain the procedure of how the exclusive locks work.

(4 Marks)

Question Three: (20 Marks)
a) Write a plsql block using case statement to display employees first_name , salary for a
particular selected employee id from employees table.

(5 Marks)

b) Define a transaction against the database and explain the four characteristics any should exhibit.

(5 Marks)
c) Explain four recovery mechanism provided by database management system.
(4 Marks)
d) Briefly describe six characteristics of distributed database management system. (6 Marks)

Question Four: (20 Marks)
a) Discuss four scenarios that one has to avoid when making indexes.

(4 Marks)
b) Explain the four implicit cursor attributes.

(4 Marks)
c) Write a Plsql code to update department_name for a specified department_id. Raise an
exception if the department supplied does not exist.

(5 Marks)
d) Explain the difference between logical and physical database design and why these tasks might be
carried out by different people?

(4 Marks)
e) Explain the basic loop.

(3 Marks)

📘 Access 10,000+ CBC Exams With Marking Schemes

Inte 214: Advanced Database Management System Question Paper

More Question Papers

Exams With Marking Schemes

End Term 3 Exams

Mid Term Exams

End Term 1 Exams

Opener Exams

Full Set Exams