Tamil Nadu Open University (TNOU) 2008 B.C.A Computer Application Introduction to database management system,,e . - Question Paper

U.G. DEGREE EXAMINATION
JUNE 2008.

(Admitted from AY-2004-05 onwards)

First Year

B.C.A.

INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

Time : 3 hours Maximum marks : 75

Answer for 5 marks questions should
not exceed 2 pages.

Answer for 10 marks questions should
not exceed 5 pages.

PART A (5 5 = 25 marks)

Answer any FIVE questions.

1.         What are important tasks of Database Manager?

2.         Explain Multi Key File organization.

3.         Define the following terms :

             (a) Foreign key

             (b) Candidate key

             (c) B-Tree

4.         Explain the hash file organization.

5.         What are two approaches to store a relation in the distributed database?

6.         What is the meaning of multi-media data?

7.         What are the techniques available for the knowledge representation?

PART B (5 10 = 50 marks)

Answer any FIVE questions.

8.         Draw a neat diagram of components of a DBMS and explain.

9.         What are the features of DBMS? Compare it with traditional file systems.

10.       Write a short note on DDL statements with an example.

11.       Describe the structure of a B+ tree

12.       Describe the characteristics of object oriented Database.

13.       Explain the DDL, DML, commands in SQL with suitable example.

14.       Describe about distributed database system in detail.