NATIONAL OPEN UNIVERSITY OF NIGERIA

UNIVERSITY VILLAGE, PLOT 91, CASDASTRAL ZONE, NNAMDI AZIKIWE EXPRESS WAY, JABI, ABUJA.
FACULTY OF SCIENCES
MARCH/APRIL 2015 EXAMINATION

COURSE CODE: CIT 844

COURSE TITLE:   Advanced Database Management System(2 Credits)

Answer 4 Questions in 2¹/₂ Hours.

Total Mark is 70 and each question carries 17^1/₂ Marks

1a. What is a relational database?  (4 marks)

1b. List and explain three (3) characteristics of a Relational Database (9 marks)

1c. Mention three basic update operations on relations (4^1/₂ marks)

2a. What is Distributed Database? (4 marks)

2b. List and explain any three (3) security measures used to protect database. (9 marks)

2c. List three (3) advantages of data distribution (4^1/₂  marks)

3a. Explain four advantages of Object Oriented Database Management System.(8 marks)

3b. Define the following Set operations in terms of relationUNION, INTERSECTION, and DIFFERENCE. (4^1/₂  marks)

3c. What is the difference between distributed and centralized database. (5 marks)

4a. What is a Transaction? (5 marks)

4b. Discuss the properties of database transactions. (8 marks)

4c. Mention three (3) responsibilities of the Schedulerfor implementing a particular strategy for concurrency control. (4^1/₂   marks)

     5a. What is an Open Source ? (7 marks)

    5b.  List three (3) advantages of an Open Source Software. (6 marks)

    5c. Mention any three (3) network topology (4^1/₂  marks)

    6a. Write short note on the following:

1. Dead lock
2. Data recovery
3.  SQL (3 marks each)

6b.  What is a database catalogue system? (4 marks)

6c. Mentionthree (3) causes of data loss from database. (4^1/₂   marks)