Download Model question papers & previous years question papers

Posted Date: 11 Aug 2014      Posted By:: deebika    Member Level: Silver  Points: 3 (₹ 4)

2014 Shanmugha Arts Science Technology and Research Academy (SASTRA) University M Tech Automobile Relational Data Base Management System (RDBMS) Question paper



Course: M Tech Automobile   University/board: Shanmugha Arts Science Technology and Research Academy (SASTRA) University

This question paper is useful for the students who are studying B.Sc(cs) 4th semester in SASTRA university. These questions related to database management system.



Relational Data Base Management System

May 2014

PART A (10 x 2 = 20)

1. Define database management system.
2. What is referred to us rotational delay?
3. Exppand the terms: (i). SEQUEL (ii)BCNF
4. Name the three aggregate functions which are provided in SQL.
5. What are objectives of normalization?
6. Define functional dependency.
7. Give two examples for semantic model.
8. Mention the drawback of relational model.
9. Write the various modes in which a data item may be locked by a transaction.
10. Give the responsibility of recovery manager.

PART B (5 x 7 = 35)

11.(a) Explain the features of entity relationship model.
(or)
(b) Describe the Btree based indexed file organization.

12.(a) Elaborate the tuple calculus system.
(or)
(b) Explain the following basic relational algebraic operations:
(i) SELECTION
(ii) PROJECTION
(iii) INTERSECTION

13.(a) Describe the inference axioms for functional dependencies.
(or)
(b)State the first two normal forms and explain with suitable examples.

14.(a) Write a note on object oriented models.
(or)
(b) Discuss the key aspects of hierarchical data base systems.

15.(a) Explain database system architechture.
(or)
(b) Describe the two phase locking protocol.

PART C (3 x 15 = 45)

16. Discuss the features of various direct access storage devices.
17. give an overview of QBE.
18. Explain the important aspects associated with multivalued dependencies.
19. Describe thenetwork data model.
20. Write a detailed note on database recovery.





Return to question paper search

Next Question Paper: University of Madras, October 2013, M.SC.(INFORMATION TECHNOLOGY)- Data warehousing and data Mining Distance mode Question Paper

Previous Question Paper: Gujarat Technological University, Examination Summer 2014, B.E. Semester : 5, Electrical Engineering, Subject : Electrical Power Utilization and Traction

Related Question Papers:


  • Electronic Devices


  • Visual programming


  • Linear ICs and its applications


  • Linear ICs and its applications


  • Linear IC's and applications


  • Categories


    Submit Previous Years University Question Papers and make money from adsense revenue sharing program

    Are you preparing for a university examination? Download model question papers and practise before you write the exam.


    Looking for University or College admissions in India for 2019 - 2020 academic year?

    APPLY NOW
    Top Contributors
    Today
      Last 7 Daysmore...

      Awards & Gifts
       
      SpiderWorks Technologies Pvt Ltd, Kochi - India. © All Rights Reserved.