Test Paper - INTRODUCTION TO DBMS - Tamil Nadu Open University - Masters in Computer Application - 1st Year - 2010, Study notes for Database Management Systems (DBMS). Tamil Nadu Open University
tycoon
tycoon22 September 2011

Test Paper - INTRODUCTION TO DBMS - Tamil Nadu Open University - Masters in Computer Application - 1st Year - 2010, Study notes for Database Management Systems (DBMS). Tamil Nadu Open University

PDF (35 KB)
2 pages
1000+Number of visits
Description
Tamil Nadu Open University ,INTRODUCTION TO DBMS, Masters in computer application , 2010, 1st Yearadvantages of DBMS, relational data model, Super key, Candidate key, Composite primary key, functional dependency, orderby...
20 points
Download points needed to download
this document
Download the document
Preview2 pages / 2
Download the document
Microsoft Word - mca755-mca05-pgdca04 _1_

M.C.A. DEGREE/P.G.D.C.A. EXAMINATION –

JUNE, 2010.

First Year

INTRODUCTION TO DBMS

Time : 3 hours Maximum marks : 75

PART A — (5 × 5 = 25 marks)

Answer any FIVE questions.

1. What are the advantages of DBMS over traditional file processing system?

2. Explain relational data model.

3. Define :

(a) Super key

(b) Candidate key

(c) Composite primary key.

4. What is functional dependency?

5. Distinguish between orderby and groupby clause.

6. Explain the concept of generalization.

7. What are the advantages of distributed database?

MCA–755 MCA–05/

PGDCA–04

MCA–755 2

PART B — (5 × 10 = 50 marks)

Answer any FIVE questions.

8. Discuss in detail about the various data models in DBMS.

9. What is normalization? Explain second normal form and third normal form with example.

10. Briefly explain the single row functions and group functions in SQL.

11. What are the basic relational algebra operations?

12. With suitable example explain the difference between subquery and join in SQL.

13. What are the features of OODBMS?

14. Elaborate client/server database.

—————

comments (0)

no comments were posted

be the one to write the first!

Download the document