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

Cop 209: Advanced Database Systems Question Paper

Cop 209: Advanced Database Systems

Course:Bachelor Of Science In Computer Science

Institution: The Presbyterian University Of East Africa question papers

Exam Year:2016

PRESBYTERIAN UNIVERSITY OF EAST AFRICA
NAKURU TOWN CAMPUS
COP 209: ADVANCED DATABASE SYSTEMS EXAM

QUESTION ONE (30 MARKS)
a) Define the following terms (10 marks)
i. Database architecture
ii. SQL
iii. Relational Table
iv. Database administrator
v. Distributed DBMS
b) State and explain the responsibilities of a database administrator. (10 marks)
c) Outline the problems that may arise in a file based system (5 marks)
d) List some of the advantages of using a database system over filing system (5 marks)
QUESTION TWO (15 MARKS)
a) What is data Integrity? Discuss the 4 groups of integrity checks on data. (10 marks)
b) Briefly describe any two key issues in distributed database design (5 marks)
QUESTION THREE (15 MARKS)
a) State 5 DBMS languages. (5 marks)
b) Using a well labelled diagram, describe the three schema architecture (10 marks)
QUESTION FOUR (15 MARKS)
a) Use SQL commands to draw a table ‘Students’ with appropriate fields. (6 marks)
b) Briefly describe the two types of distributed DBMSs (4 marks)
c) Define ‘Query’ and give 4 examples of queries used in designing a database (5 marks)
QUESTION FIVE (15 MARKS)
a) Outline the potential disadvantages of database systems (5 marks)
b) What is MySQL? Describe four basic MySQL commands (5 marks)
c) State four examples of database management systems (5 marks)

Cop 209: Advanced Database Systems Question Paper

More Question Papers

Popular Exams