Scribd
Upload
6 views4 pages

DBMS Important Questions

The document outlines important questions and topics related to Database Management Systems, organized into five units covering relational databases, database design, transactions, implementation techniques, and advanced topics. Each unit includes questions categorized by difficulty level, with high, medium, and low marks assigned to various concepts such as SQL, normalization, ACID properties, indexing, and NoSQL databases. The structure serves as a study guide for understanding key principles and practices in database management.

Uploaded by

graj66486
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
6 views4 pages

DBMS Important Questions

The document outlines important questions and topics related to Database Management Systems, organized into five units covering relational databases, database design, transactions, implementation techniques, and advanced topics. Each unit includes questions categorized by difficulty level, with high, medium, and low marks assigned to various concepts such as SQL, normalization, ACID properties, indexing, and NoSQL databases. The structure serves as a study guide for understanding key principles and practices in database management.

Uploaded by

graj66486
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

Database Management Systems -

Important Questions
UNIT I – RELATIONAL DATABASES

2 Marks (High)
- Define Database System and its purpose.
- What are Data Models?
- Define Relational Model.
- What is a Primary Key?
- Define Relational Algebra.
- What is SQL?

2 Marks (Medium)
- What are Views of Data?
- List types of Keys.
- What is Database Architecture?
- Define Tuple and Attribute.
- What is Embedded SQL?

2 Marks (Low)
- Define Domain.
- What is Dynamic SQL?
- Expand DDL, DML.

16 Marks (High)
- Explain Relational Model concepts and keys.
- Discuss Relational Algebra operations with examples.
- Explain SQL fundamentals and advanced SQL features.

16 Marks (Medium)
- Describe Database System Architecture.
- Explain Views of Data and Data Models.

16 Marks (Low)
- Explain Embedded SQL and Dynamic SQL.
UNIT II – DATABASE DESIGN

2 Marks (High)
- Define Entity and Attribute.
- What is an E-R Diagram?
- Define Functional Dependency.
- What is Normalization?
- Define 1NF, 2NF, 3NF.

2 Marks (Medium)
- What is BCNF?
- Define Multivalued Dependency.
- What is Lossless Decomposition?

2 Marks (Low)
- Define 5NF.
- What is Join Dependency?

16 Marks (High)
- Explain E-R Model with diagram.
- Discuss Normalization (1NF to 3NF).
- Explain Functional Dependencies and Decomposition.

- Explain ER to Relational Mapping.


- Discuss BCNF and 4NF.

16 Marks (Low)
- Explain 5NF and Join Dependencies.

UNIT III – TRANSACTIONS

2 Marks (High)
- Define Transaction.
- What are ACID Properties?
- Define Serializability.
- What is Deadlock?

2 Marks (Medium)
- What is a Schedule?
- Define Two Phase Locking.
- What is Timestamp Ordering?
2 Marks (Low)
- Define Shadow Paging.
- What is ARIES Algorithm?

16 Marks (High)
- Explain ACID properties and Transaction concepts.
- Discuss Concurrency Control techniques.
- Explain Deadlock handling methods.

16 Marks (Medium)
- Explain Serializability and Schedules.
- Discuss Recovery techniques.

16 Marks (Low)
- Explain ARIES Algorithm and Shadow Paging.

UNIT IV – IMPLEMENTATION TECHNIQUES

2 Marks (High)
- Define RAID.
- What is Indexing?
- Define Hashing.
- What is B+ Tree?

2 Marks (Medium)
- What is File Organization?
- Define Query Processing.
- What is Cost Estimation?

2 Marks (Low)
- Define Column-Oriented Storage.
- What is Dynamic Hashing?

16 Marks (High)
- Explain Indexing techniques.
- Discuss Hashing techniques.
- Explain Query Processing and Optimization.

16 Marks (Medium)
- Explain RAID levels and File Organization.
- Discuss Join, Sorting, Selection Algorithms.
16 Marks (Low)
- Explain Column-Oriented Storage and Data Dictionary.

UNIT V – ADVANCED TOPICS

2 Marks (High)
- Define Distributed Database.
- What is CAP Theorem?
- Define NoSQL Database.
- What is SQL Injection?

2 Marks (Medium)
- What is Role-Based Access Control?
- Define Graph Database.
- What is Encryption?

2 Marks (Low)
- Define Flow Control.
- What is Statistical Database Security?

16 Marks (High)
- Explain CAP Theorem and NoSQL databases.
- Discuss Distributed Database Architecture.
- Explain Database Security and SQL Injection.

16 Marks (Medium)
- Explain types of NoSQL databases.
- Discuss Access Control and Encryption.

16 Marks (Low)
- Explain Statistical Database Security and Flow Control.

You might also like