Tamil Nadu Open University (TNOU) 2008 B.C.A Computer Application Introduction to database management system,,e . - Question Paper
This beneath ques. paper is related to introduction to database management system of B.C.A .
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.
Earning: Approval pending. |