Trending ▼   ResFinder  

TAMIL NADU OPEN UNIVERSITY MCA - I (SEM 1) JUN 2010 : Introduction To Database Management Systems

2 pages, 16 questions, 0 questions with responses, 0 total responses,    0    0
mca_india
  
+Fave Message
 Home > mca_india >

Formatting page ...

MCA 755 MCA 05/ PGDCA 04 M.C.A. DEGREE/P.G.D.C.A. EXAMINATION JUNE, 2010. First Year INTRODUCTION TO DBMS Time : 3 hours PART A (5 Maximum marks : 75 5 = 25 marks) Answer any FIVE questions. 1. What are the advantages of traditional file processing system? DBMS over 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? 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. 2 MCA 755

Formatting page ...

 

  Print intermediate debugging step

Show debugging info


 

Additional Info : Mca - I (sem 1) June 2010 Question Paper - Introduction To Database Management Systems
Tags : mca exam papers, mca question papers, ignou mca question papers, ptu mca question papers, mca sample question paper, mca mumbai university question papers, mca exam syllabus, mca exam question paper, online mca exam papers, online mca exam preparation, mumbai university mca question papers, ignou university mca question papers  


© 2010 - 2025 ResPaper. Terms of ServiceContact Us Advertise with us

 

mca_india chat