Need help about a course?

Colleges & Universities | Distance Education | Admission Notifications | Entrance Exams
Course Syllabus | Question Papers | Campus Events | IGNOU
Home / Test Papers / University of Madras / ICE / Degree / BCA / Database Management Systems Ask a question
Print this page
University of Madras (UnOM)
Database Management Systems
Database Management Systems
U/IC 14660/NCG

Time: Three hours
Maximum: 100 marks

PART A - (10 x 2 = 20 marks)
Answer ALL questions.
All questions carry equal marks.

1. What is Database Management System?

2. What is canonical schema?

3. List down the area characteristics of DDL.

4. What is Data Independence?

5. Define:
(a) Paging
(b) Staging.

6. What are homogeneous and heterogeneous trees?

7. Mention the objectives of storing the relationships separately from data.

8. What are triad queries?

9. How do you measure the hit rate?

10. Name the four levels of storage hierarchy.

PART B - (5 x 7 = 35 marks)

Answer ALL questions.
All questions carry equal marks.

11. (a) Explain the four major components of a database system.


(b) What is functional dependency? Explain with examples.

12. (a) With an example explain how can a plex structure be normalized.


(b) What are the various types of entries in which a schema is written in the CODASYL DDL.

13. (a) Distinguish between the logical and physical organization of data.


(b) What are pointers? Explain its advantages and disadvantages.

14. (a) Write short notes on multiple key retrieval.


(b) Describe indexed sequential access method with suitable examples.

15. (a) What is data compactness? How is it achieved?


(b) Explain any three memory replacement algorithms.

PART C - (3 x 15 = 45 marks)

Answer any THREE questions.
All questions carry equal marks.

16. What is a binary tree? Explain how a binary tree can be represented as an array.

17. List and explain the primary objectives of a Database Management System.

18. Define 3 NF. Give an example of a relation which is not in 3 NF and show how it is converted into 3 NF.

19. What is addressing? Explain any five addressing techniques.

20. Write short notes on:

(a) Virtual memory.
(b) Database security.

Most popular pages

Business Schools - Engineering Colleges - Medical & Nursing Admissions - BEd in Distance mode - Journalism & Media Studies

Follow IndiaStudyCenter on Twitter

Search this site