Download Model question papers & previous years question papers
Submit Previous Years University 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
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.
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.
b) Discuss the concept of E-R Model.
12.a) Write a note on Keys.
b) Explain the correlated nested queries on tables with suitable examples.
13.a) Discuss the usage of set operations with example queries.
b) Explain the concept of dependency preserving decomposition.
14.a) Explain the characteristics of valid transactions.
b) Write a note on Serializability.
15.a) Discuss the concept of Hash based indexing.
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
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.
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.