197295

C 21505 (Pages : 2) पपि या © ०००००००००००००००००००००००००००००००००००००००००

FOURTH SEMESTER (CBCSS—UG) DEGREE EXAMINATION, APRIL 2022
B.C.A./Computer Science
BCA 4B 05/BCS 4B 04—DATABASE MANAGEMENT SYSTEM AND RDBMS
(2019 Admission onwards)
Time : Two Hours Maximum : 60 Marks
Section A (Short Answer Type Questions)

Answer at least eight questions.
Each question carries 3 marks.
All questions can be attended.

Overall Ceiling 24.

1. What are the responsibilities of DBA ?
2. What are the different Relationship Sets ? Explain.
3. Explain the use of foreign key constraint ?
4. Define Relationship and Relationship set ?
5. Write short notes on tuple relational calculus.
6. Discuss how can you change the data in the table ?
7. Define correlated nested queries.
8. Discuss about different operators used in algebra.
9. Define transaction management.
10. Advantages and Disadvantages of Stored Procedures.
11. Write a note on DDL, DML.
12. Discuss how can you change the data in the table ?

(8 x 3 = 24 marks)

Turn over

197295