367162

C 41184 (Pages : 2) पिथ.
நத... ‏یما‎
‎FOURTH SEMESTER (CBCSS—UG) DEGREE EXAMINATION
APRIL 2023
B.C.A/B.C.S.

Time:

10.
11.
12.

13.
14.

BCA 4B 05/BCS 4B 05—DATABASE MANAGEMENT SYSTEM AND RDBMS
(2019 Admission onwards)

Two Hours Maximum : 60 Marks
Section A (Short Answer Type Questions)

Answer all questions, each correct answer carries a maximum of 2 marks.

Ceiling 20 marks.
Write the duties of a database administrator.
What is relational model ? Explain.
Define data independence.
Differentiate primary key and foreign key with a suitable example.
Discuss the concept of Entity.
Write the need of normalization.
What are good and bad decompositions ?
What are aggregate functions ?
Write the use of group by clause.
What is a view ? Explain with an example.
What is deadlock ? Explain.
What is the use of cursors ?

Section B (Short Essay Type Questions)

Answer all questions, each correct answer carries a maximum of 5 marks.
Ceiling 30 marks.
Discuss different extended E-R features.
Write the advantages and disadvantages of using DBMS approach.

Turn over

367162