Download Model question papers & previous years question papers
|
Posted Date: 14 Feb 2022 Posted By:: Jannane.M Member Level: Gold Points: 3 (₹ 3)
|
2021 Bharathidasan University Bharathidasan University, M.C.A Degree Examination, Computer Applications, Database Systems, Nov 2021. Question paper
Are you looking for the old question papers from Bharathidasan University of Database Systems paper? Here is the previous year question paper from Bharathidasan University. This is the original question paper of Database Systems exam conducted in Nov 2021. Feel free to download the question paper from here and use it to prepare for your upcoming exams.
S.No. 4319
P 20 MCA 2
(For candidates admitted from 2020–2021 onwards)
M.C.A DEGREE EXAMINATION, NOVEMBER 2021.
Computer Applications
DATABASE SYSTEMS
Time : Three hours
Maximum : 75 marks
SECTION A — (10 2 = 20)
Answer ALL questions.
1.
What is the E–R Model?
2.
What are the advantages of using a DBMS?
3.
Write Integrity Rules in DBMS?
4.
What is BCNF?
5.
What are the advantages of Indexing?
6.
Write short notes on B-Tree Index.
7.
Give the reasons for allowing concurrency.
8.
What are the states of Transaction?
9.
Show code of a cursor ?For loop?.
10. Define Triggers.
SECTION B — (5 5 = 25)
Answer ALL questions, choosing either (a) or (b) in each.
11. (a) Define the terms :
(i) Entity type and Entity set
(ii) Weak Entity set
(iii) Strong Entity set
Or
(b) Explain the concept of Database Management system.
12. (a) Explain about 1 NF and 2 NF with examples.
Or
(b) Discuss about Functional Dependencies and its uses.
13. (a) Differentiate Static and Dynamic Hashing.
Or
(b) What is a B+ Tree Index and Hash Index?
14. (a) Describe about concurrency control schemes.
Or
(b) Elaborate the concept of various Transaction – states.
15. (a) Define View. How to create a view with examples.
Or
(b) What are the different types of statements supported by SQL?
SECTION C — (3 10 = 30)
Answer any THREE Questions.
16. What is a Data Model? Explain the types of Data Model used.
17. Explain 4 NF and 5 NF with examples.
18. Discuss about File Organization and its types.
19. Describe about the Lock based protocol with examples.
20. Describe about various kinds of Triggers.
Return to question paper search
|
|
|
|
|
|
|
|
Related Question Papers:
Bharathidasan University, M.com Degree Examination, Computer Applications, E-Commerce, Nov 2021.
Bharathidasan University, M.B.A Degree Examination, Business Administration, Managerial Economics, Nov 2021.
Bharathidasan University, M.I.B. Degree Examination, International Business, India's Foreign Trade and Legislations, Nov 2021.
Bharathidasan University, M.A Degree Examination, Political Science, Human Rights, Nov 2021.
Bharathidasan University, M.C.A Degree Examination, Computer Applications, Data Structures and Algorithms, Nov 2021.
|
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.