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)
More Question Papers
Exams With Marking Schemes