Scribd
Upload
16 views1 page

Database Management Systems Exam 2024

This document outlines the examination structure for the CS2341 - Database Management Systems course for the academic year 2024-25. It includes three parts: Part A consists of short answer questions, Part B contains detailed questions requiring explanations and examples, and Part C focuses on applying commands and discussing model correspondence. The exam assesses various topics related to database management, including ER models, recovery techniques, and SQL concepts.

Uploaded by

Poovizhi Balan
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
16 views1 page

Database Management Systems Exam 2024

This document outlines the examination structure for the CS2341 - Database Management Systems course for the academic year 2024-25. It includes three parts: Part A consists of short answer questions, Part B contains detailed questions requiring explanations and examples, and Part C focuses on applying commands and discussing model correspondence. The exam assesses various topics related to database management, including ER models, recovery techniques, and SQL concepts.

Uploaded by

Poovizhi Balan
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

[Link].

Department of Computer Science and Engineering


&
Department of Information Technology
AY 2024-25 II Year IV Sem REHEARSAL
CS2341 – DATABASE MANAGEMENT SYSTEMS
Duration: 3 Hrs Max. Marks: 100

PART - A (10 x 2 = 20 MARKS)


ANSWER ALL THE QUESTIONS:
1. What is storage manager? (R)
2. Differentiate between 2NF and 3NF. (U)
3. Define cardinality ratio for binary relationship. (R)
4. List the features of ER model. (U)
5. Demonstrate the techniques available for recovery. (AP)
6. Point out the statements associated with a database transaction. (R)
7. What is meant by mean time to failure? (R)
8. What are the conditions should be satisfied, for calling a database as distributed? (E)
9. List the three types of XML documents. (AP)
10. Compose committed transaction and rollback concept. (C)
PART - B (5 x 13 = 65 MARKS)
ANSWER THE FOLLOWING QUESTIONS:
11. a. Draw the architecture of database with detail explanation. (R)
(OR)
b. i) Discuss in detail about the relational algebra operations with example. (7) (AN)
ii)Explain the concepts of keys with its types and suitable example. (6) (U)
12. a. i) Discuss the concept of mapping cardinalities with its types and suitable diagram. (7) (AN)
ii) Explain the concept of enhanced ER model with suitable example. (6) (C)
(OR)
b. Demonstrate the concept of functional dependencies with Armstrong axiom’s rule. (AP)
13. a. Enumerate the concept of locking protocols with suitable example. (R)
(OR)
b. i) Discuss about the log-based recovery with working procedure. (7) (U)
ii)Explain about the transaction recovery with failure classification, recovery and atomicity. (6) (C)
14. a. i) Discuss about the concept of ordered indices with suitable example. (R)
ii) Illustrate about the B+ tree index files with suitable example. (AN)
(OR)
b. i) Compose the concept for organization of records in files with and suitable diagram. (7) (C)
ii) Discuss in detail about the file organization concept with organization of records in files. (6) (U)

15. a. i) Explain about the concept of SQL injection with a neat sketch. (7) (AP)
ii) Discuss about the NoSQL Database. (6) (U)
(OR)
b. Outline the concept of XML schema with example program. (R)
PART - C (1 x 15 = 15 MARKS)
ANSWER THE FOLLOWING QUESTIONS:
16. a. Apply DDL, DML, DCL commands with one example database for faculty detail. (AP)
(OR)
b. Discuss the correspondence between the ER model construct and the relational model (AN)
constraints. Show how each ER model construct can be mapped to the relational model. Discuss
the option for mapping EER model construct.

ACADEMIC COUNSELOR HoD / CSE & IT

NOTE: R- Remember, U- Understand, AP- Apply, AN- Analyze, E- Evaluate, C- Create

You might also like