For More Quiz Questions click here to download Global Quiz on Google PlayStore

NATIONAL OPEN UNIVERSITY OF NIGERIA

UNIVERSITY VILLAGE, PLOT 91, CASDASTRAL ZONE, NNAMDI AZIKIWE EXPRESS WAY, JABI, ABUJA.
FACULTY OF SCIENCES
OCTOBER 2013 EXAMINATION

Course Code:   CIT 844                                                                                       

Time Allowed:   2½ hrs

Course Title:    Advanced Database Management System

Course Unit:    2 Credits

Total mark is 100 and each question carries 25 marks

Answer 4 Questions.

 

1a. Explain what a Database is?       (4 marks)

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

1c. Mention three (3) advantages of database  (9 marks)

 

2a. What is an open source?   (7 marks)

2b. List three advantages of open source software.   (9 marks)

2d. Mention any three network topology   (9 marks)

 

3a. Write short note on the following:

  1. Data Integrity
  2. Data Security
  3.  Data Privacy      (4 marks each)

 

3b. Differentiate between a centralized and distributed database systems   (8 marks)

3c. Explain what encryption is?   (5 marks)

 

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

4b.Give the full meaning of the following acronyms:

(i)OODBMS

(ii) ORDBMS

(iii) GIGO

(iv) DDL

(v)SDLC

(vi) PC

(vii) DBMS      (2 mark each)

 

4c. Identify any three database models     (6 marks)

 

5a. What is SQL?   (5 marks)

5b. List any five (5) operators and their description in SQL.     (10 marks)

5c. List five (5) failures that could make the DBMS require recovery  (10 marks)

 

6a. Explain what Relational Database is? (7 marks)

6b. Differentiate between Single User and Multiple User  (8 marks)

6d. Outline four (4) maintenance activities by the database administrator.  (8 marks)


For More Quiz Questions click here to download Global Quiz on Google PlayStore


Select NOUN Past Questions & Answers by Faculties

Sciences

National Open University of Nigeria (NOUN) Faculty of Sciences Past Questions and Answers.

Education

National Open University of Nigeria (NOUN) Faculty of Education Past Questions and Answers.

Arts & Social Sciences

National Open University of Nigeria (NOUN) Faculty of Arts and Social Sciences Past Questions and Answers.

Law

National Open University of Nigeria (NOUN) Faculty of Law Past Questions and Answers.

Management Sciences

National Open University of Nigeria (NOUN) Faculty of Management Sciences Past Questions and Answers.

Health Sciences

National Open University of Nigeria (NOUN) Faculty of Health Sciences Past Questions and Answers.

Agriculture Sciences

National Open University of Nigeria (NOUN) Faculty of Agricultural Sciences Past Questions and Answers.

Select Project Topics & Materials by Categories

Accounting

Universities, Polytechnic's and Colleges of Education Accounting Project Topics and Materials.

Biology

Universities, Polytechnic's and Colleges of Education Biology Project Topics and Materials.

Business Education

Universities, Polytechnic's and Colleges of Education Business Education Project Topics and Materials.

Chemistry

Universities, Polytechnic's and Colleges of Education Chemistry Project Topics and Materials.

Computer Science

Universities, Polytechnic's and Colleges of Education Computer Science Project Topics and Materials.

Criminology & Security

Universities, Polytechnic's and Colleges of Education Criminology & Security Project Topics and Materials.

Economics

Universities, Polytechnic's and Colleges of Education Economics Project Topics and Materials.

Education

Universities, Polytechnic's and Colleges of Education Education Project Topics and Materials.

English/Linguistic

Universities, Polytechnic's and Colleges of Education English/Linguistic Project Topics and Materials.

Entrepreneurship

Universities, Polytechnic's and Colleges of Education Entrepreneurship Project Topics and Materials.

Environmental Science

Universities, Polytechnic's and Colleges of Education Environmental Science Project Topics and Materials.

Law

Universities, Polytechnic's and Colleges of Education Law Project Topics and Materials.

Marketing

Universities, Polytechnic's and Colleges of Education Marketing Project Topics and Materials.

Physics

Universities, Polytechnic's and Colleges of Education Physics Project Topics and Materials.

Political Science

Universities, Polytechnic's and Colleges of Education Political Science Project Topics and Materials.

Public Administration

Universities, Polytechnic's and Colleges of Education Public Administration Project Topics and Materials.

How to login to NOUN Elearn Portal

You can now use you matric number to login as your username and  password in a lowercase.

https://elearn.nouedu2.net/login/

Note that you are to change your passw...

Facebook posts