Bharathidasan University MCA Database Systems Nov 2021 Question Paper Download

Bharathidasan University Question Papers- Old Question Papers / Past and Previous Years Question Papers

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

Share This