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

Course: M.C.A   University/board: Bharathidasan University

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)


Computer Applications


Time : Three hours

Maximum : 75 marks

SECTION A — (10 2 = 20)

Answer ALL questions.

What is the E–R Model?

What are the advantages of using a DBMS?

Write Integrity Rules in DBMS?

What is BCNF?

What are the advantages of Indexing?

Write short notes on B-Tree Index.

Give the reasons for allowing concurrency.

What are the states of Transaction?

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


(b) Explain the concept of Database Management system.

12. (a) Explain about 1 NF and 2 NF with examples.


(b) Discuss about Functional Dependencies and its uses.

13. (a) Differentiate Static and Dynamic Hashing.


(b) What is a B+ Tree Index and Hash Index?

14. (a) Describe about concurrency control schemes.


(b) Elaborate the concept of various Transaction – states.

15. (a) Define View. How to create a view with examples.


(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

Next Question Paper: Bharathidasan University, M.C.A Degree Examination, Computer Applications, Enterprise Resource Planning, Nov 2021.

Previous Question Paper: IGNOU Papers of TEE, December 2019, Bachelor's Degree Programme,EPS-09 : Comparative Government And Politics

Related Question Papers:

  • Bharathidasan University, 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.

    Looking for University or College admissions in India for 2023 - 2024 Academic Year?

    Top Contributors
    TodayLast 7 Daysmore...

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