Tamil Nadu Open University (TNOU) 2009-1st Year B.C.A Computer Application " INTRODUCTION TO DBMS " UG 417 06 - Question Paper
UG-417 BCA-06
U.G. DEGREE EXAMINATION JANUARY, 2009.
(Admitted from AY 2004-05 batch onwards) First Year B.C.A.
INTRODUCTION TO DBMS
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 x 5 = 25 marks)
Answer any FIVE questions.
1. Write the functions of DBA.
2. What are the properties of relation? Explain with example.
3. With relevant examples discuss primary key and foreign key.
4. Write the basic operations of relational model with an example.
5. Discuss about Data Definition Language.
6. Write short notes on distributed databases.
7. What is a knowledge database? Discuss.
PART B (5 x 10 = 50 marks)
Answer any FIVE questions.
8. Explain in detail relationship between entity sets.
9. Explain primary indexes and clustering indexes.
10. Explain about multilist file organisation.
11. Discuss about BCNF, 4NF and 5NF.
12. Explain the aggregate functions in SQL with examples.
13. Explain the features of OODBMS.
14. Discuss in detail Client Server computing paradigm.
2 UG-417
Attachment: |
Earning: Approval pending. |