IT-405 · Data Base Management System/Unsolved PYQ Paper
DATA BASE MANAGEMENT SYSTEM - NOV 2023 Question Paper
-
Unit 17 MarksaDescribe basic architecture of Database Management System in detail.
-
Unit 17 MarksbExplain the Functions of database Administrator.
-
Unit 17 MarksaWhat is ER-model? Explain the basic symbols used of entities, attributes and relationships.
-
Unit 17 MarksbWhat is an Attribute? Explain various types of attribute with examples.
-
Unit 27 MarksaExplain integrity constraint over relations.
-
Unit 27 MarksbHow to alter, destroy and views table? Explain with suitable queries.
-
Unit 27 MarksaExplain Fundamental operations in relational algebra with examples.
-
Unit 37 MarksbWhat are the steps to be followed to convert a relation in 3NF to BCNF?
-
Unit 54 MarksiExplain Optimization methods. i) Heuristic based
-
Unit 53 MarksiiExplain Optimization methods. ii) Cost Estimation based
-
Unit 47 MarksbHow to test Serializability of Schedule? Explain with example.
-
Unit 47 MarksaExplain log-based recovery Protocol.
-
Unit 47 MarksbExplain Multiple Granularity Concurrency control scheme.
-
Unit 27 MarksaWhat is view? Give brief note on view.
-
Unit 17 MarksbState and explain various File Organization Methods.
-
Unit 27 MarksaWrite short notes on any two: a) Assertions
-
Unit 57 MarksbWrite short notes on any two: b) Web and Mobile database
-
Unit 27 MarkscWrite short notes on any two: c) Hierarchical queries
-
Unit 47 MarksdWrite short notes on any two: d) Validation based protocols
Go to where you left off?
Quick Add to Notes
Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.
Create free accountHave an account? Log in
Notes Panel