Alagappa University Computer Alagappa University, Distance Education, B.C.A Degree Examination, Relational Database Management System,Dec 2020. model question papers



Download Model question papers & previous years question papers

Posted Date: 20 Mar 2021      Posted By:: Jannane.M    Member Level: Gold  Points: 3 (₹ 2)

2020 Alagappa University Computer B.C.A. Alagappa University, Distance Education, B.C.A Degree Examination, Relational Database Management System,Dec 2020. Question paper



Course: B.C.A.   University/board: Alagappa University

Are you looking for the old question papers from Alagappa University of Relational Database Management System paper? Here is the previous year question paper from Alagappa University. This is the original question paper of Relational Database Management System exam conducted in December 2020.Feel free to download the question paper from here and use it to prepare for your upcoming exams.



D-4780

Distance Education

B.C.A Degree Examination, Dec 2020

DATA STRUCTURES AND ALGORITHMS

(CBCS 2018-19 academic year onwards)

Time : Three Hours Maximum : 75 marks

PART A - (10×2=20 marks)

Answer all questions

1. Define : Schema

2. What is meant by instance? Give an example.

3. Define : DML

4. State the syntax / query to create a table with four attributes.

5. What is meant by Referential Integrity?

6. Define : Inner Join

7. Give examples of any Four aggregate functions.

8. Define : 3NF

9. What is meant by Exclusive lock in concurrent transactions?

10. Define Binary trees.

PART B - ( 5×5=25 marks)

Answer all questions choosing either (a) or (b)

11.a) List any Five features of database system.

Or

b) Discuss the concept of E-R Model.

12.a) Write a note on Keys.

Or

b) Explain the correlated nested queries on tables with suitable examples.

13.a) Discuss the usage of set operations with example queries.

Or

b) Explain the concept of dependency preserving decomposition.

14.a) Explain the characteristics of valid transactions.

Or

b) Write a note on Serializability.

15.a) Discuss the concept of Hash based indexing.

Or

b) Give an account on B+ trees.

PART C - ( 3×10=30 marks)

Answer any Three questions

16. Describe the characteristics of various data models.

17. Explain the operations on Relational calculus with suitable queries.

18. Elaborate on various normal forms with example.

19. Explain the working of Time stamp based protocols on concurrent transactions.

20. Describe about Indexed sequential access methods.





Return to question paper search

Next Question Paper: Alagappa University, Distance Education, B.Sc Degree Examination, Data Structures and Algorithms,Dec 2020.

Previous Question Paper: Karnataka Secondary Education Examination Board Secondary School Leaving Certificate Examination June 2019 Third Language Hindi, New Syllabus, Regular Repeater

Related Question Papers:


  • Alagappa University, Distance Education, B.A English Degree Examination, Victorian Literature, Third Semester, Dec 2020.


  • Alagappa University, Distance Education, B.sc (Information Technology) Degree Examination, Internet and Java Programming, Third Semester, Dec 2020.


  • Alagappa University, Distance Education, B.A History Degree Examination, History of Europe, Third Semester, Dec 2020.


  • Alagappa University, Distance Education, B.com (CA) Degree Examination, Principles of C Programming, Third Semester, Dec 2020.


  • Alagappa University, Distance Education, B.B.A. Degree Examination, Organisational Behaviour, Dec 2020.


  • 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 2021 - 2022 Academic Year?

    APPLY NOW
    Top Contributors
    TodayLast 7 Daysmore...

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