Scribd
Upload
181 views2 pages

BCS4 B05 & Bca4 B05 - Database - Management - Systems - and - RDBMS

This document is an examination paper for the Fourth Semester B.Sc./B.C.A. Degree in April 2023, focusing on Database Management Systems and RDBMS. It includes three parts: Part A with short answer questions, Part B with short essay questions, and Part C with essay questions, covering various topics related to database concepts and operations. The exam has a total duration of 2 hours, a maximum score of 60 marks, and is intended for students admitted in 2019 and onwards.

Uploaded by

Dinu Sreekumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
181 views2 pages

BCS4 B05 & Bca4 B05 - Database - Management - Systems - and - RDBMS

This document is an examination paper for the Fourth Semester B.Sc./B.C.A. Degree in April 2023, focusing on Database Management Systems and RDBMS. It includes three parts: Part A with short answer questions, Part B with short essay questions, and Part C with essay questions, covering various topics related to database concepts and operations. The exam has a total duration of 2 hours, a maximum score of 60 marks, and is intended for students admitted in 2019 and onwards.

Uploaded by

Dinu Sreekumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

21U413 (Pages: 2) Name: ...................................

Reg.No: ...................................

FOURTH SEMESTER B.Sc./B.C.A. DEGREE EXAMINATION, APRIL 2023


(CBCSS - UG)
(Regular/Supplementary/Improvement)
CC19U BCS4 B05 / CC19U BCA4 B05 - DATABASE MANAGEMENT SYSTEMS AND RDBMS
(Computer Science / Computer Application - Core Course)
(2019 Admission onwards)
Time : 2.00 Hours Maximum : 60 Marks
Credit : 3

Part A (Short answer questions)


Answer all questions. Each question carries 2 marks.

1. List functions of DBA.

2. Define DML.

3. List different type of constraints.

4. Define Records in relational model.

5. Define candidate key.

6. Define fourth normal form.

7. Define select command with example.

8. Write command for creating view.

9. What is composite query?

10. Explain concurrency.

11. Write the syntax of delete statement.

12. Give any two advantages of stored procedure.


(Ceiling: 20 Marks)
Part B (Short essay questions - Paragraph)
Answer all questions. Each question carries 5 marks.

13. Give a detailed note on EER.

14. Give a short note on Relational algebra.

15. Explain Updation anomaly with example.

16. Explain First and second normal form with example.

17. Explain create and insert statement with example.


18. Explain aggregate functions.

19. Explain desirable properties of transaction.


(Ceiling: 30 Marks)
Part C (Essay questions)
Answer any one question. The question carries 10 marks.

20. Explain File System and DBMS in detail.

21. What are the main differences between Relational data model and ER model? Explain ER model.
(1 × 10 = 10 Marks)

*******

You might also like