Download Model question papers & previous years question papers

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

2014 Shanmugha Arts Science Technology and Research Academy (SASTRA) University B.Sc Electronics Relational database management system (RDBMS) Question paper



Course: B.Sc Electronics   University/board: Shanmugha Arts Science Technology and Research Academy (SASTRA) University

This question paper is from SASTRA university, B.Sc (electronics and computer science), semester 4. This paper is related to database management. These questions checks your database manipulation skills.



RDBMS
Duration : 3 hours
Marks : 100

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: B.A Statistics Examination (IInd Year) Paper-2 (Statistical Inference) Question Paper

Previous Question Paper: B.Sc Bio-Chemistry Examination (IInd Year) Paper-2 (Enzymology and Intermediary Metabolism) Question Paper

Related Question Papers:


  • Relational Data Base Management System (RDBMS)


  • Electronic Devices


  • Visual programming


  • Linear ICs and its applications


  • Linear ICs and its 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
    TodayLast 7 Daysmore...

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