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

Popular Exams


Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams



Return to Question Papers