Bharathidasan University Bharathidasan University, M.C.A Degree Examination, Computer Applications, Database Systems, Nov 2021. model question papers



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)

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

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, 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.


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

    APPLY NOW
    Top Contributors
    TodayLast 7 Daysmore...

    Awards & Gifts

    Online Members

    More...
     
    SpiderWorks Technologies Pvt Ltd, Kochi - India. © All Rights Reserved.