Scribd
Upload
225 views2 pages

DBMS RGPV Imp Questions Unit Vise

The document outlines various concepts in database management, comparing traditional file systems with DBMS, and discussing the Entity-Relationship model, data independence, and types of data models. It also covers relational database keys, integrity constraints, normalization, transaction processing, and advanced topics like distributed databases and OODBMS. Additionally, it includes practical SQL query examples and discusses the architecture of popular database systems.

Uploaded by

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

DBMS RGPV Imp Questions Unit Vise

The document outlines various concepts in database management, comparing traditional file systems with DBMS, and discussing the Entity-Relationship model, data independence, and types of data models. It also covers relational database keys, integrity constraints, normalization, transaction processing, and advanced topics like distributed databases and OODBMS. Additionally, it includes practical SQL query examples and discusses the architecture of popular database systems.

Uploaded by

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

UNIT -1

compare the Database approach with the Traditional file accessing


approach. Explain the advantages of Database Management Systems
(DBMS) over traditional file systems.

 What is the Entity-Relationship (ER) model? Explain the concepts of


Generalization, Aggregation, and Specialization with suitable examples.

 Define and differentiate between Schema and Instance. Explain the


concept of Data Independence and its types with examples.

 Explain the different types of Data Models (Relational, Network, and


Object-Oriented). Compare these models with respect to structure,
applications, and advantages.

 What are Hashing and Indexing? Explain the difference between Single-
level and Multi-level indexing with examples.

UNIT -2

 What are Keys in a relational database? Explain the different types of


keys (Primary Key, Candidate Key, Foreign Key) with examples.

 Define Referential Integrity and Integrity Constraints. Explain their


importance in relational databases with suitable examples.

 Explain the fundamental operations of Relational Algebra, such as


Select, Project, Join, and Division, with examples.

 What is SQL? Differentiate between DDL and DML. Write SQL queries to
demonstrate Joins and Triggers.

 Differentiate between Tuple-Oriented and Domain-Oriented Relational


Calculus. Write examples to explain their operations..

UNIT-3

 What is Normalization? Explain the different normal forms (1NF, 2NF,


3NF, and BCNF) with examples.

 What is Functional Dependency? How does it help in achieving


normalization? Explain with examples.

 What is Decomposition in database design? Explain Dependency


Preservation and Lossless Join properties with examples.
UNIT -1

 What are the problems associated with null values and dangling tuples
in relational databases? Provide examples to illustrate these issues.

 Explain Query Optimization. Discuss heuristic-based and cost


estimation-based optimization methods, and provide examples of select,
project, and join operations.

UNIT -4

 What is Serializability in transaction processing? Differentiate between


conflict-serializable and view-serializable schedules with examples.

 Explain the Log-Based Recovery mechanism and the role of checkpoints


in recovering from transaction failures.

 What are Concurrency Control Techniques? Explain locking protocols


and timestamping protocols with examples.

 Write short notes on Distributed Databases, Data Mining, and Data


Warehousing. Highlight their features and applications.

 Compare OODBMS (Object-Oriented DBMS) with traditional DBMS.


Discuss the advantages and limitations of OODBMS.

UNIT -5

 Explain the architecture of Oracle/PostgreSQL/MySQL. Discuss the roles


of physical files, memory structures, and background processes.

 What is a Data Dictionary? Explain the significance of dynamic


performance views in relational database management systems.

 Write and explain SQL queries for hierarchical queries, inline queries,
and flashback queries with examples.

 What are Cursors? Differentiate between nested cursors and


parameterized cursors with examples.

 What are Triggers? Explain mutating errors and the concept of 'Instead
Of' triggers with examples.

You might also like