Scribd
Upload
8 views2 pages

Important Questions RDBMS

The document outlines important questions related to Relational Database Management Systems (RDBMS) across five units, covering topics such as file systems, DBMS advantages, normalization, SQL commands, ACID properties, and distributed databases. It includes both long and short questions aimed at assessing knowledge in database concepts, structures, and functionalities. The content serves as a study guide for understanding key principles and practices in RDBMS.

Uploaded by

foledi8573
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
8 views2 pages

Important Questions RDBMS

The document outlines important questions related to Relational Database Management Systems (RDBMS) across five units, covering topics such as file systems, DBMS advantages, normalization, SQL commands, ACID properties, and distributed databases. It includes both long and short questions aimed at assessing knowledge in database concepts, structures, and functionalities. The content serves as a study guide for understanding key principles and practices in RDBMS.

Uploaded by

foledi8573
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

Relational Database Management Systems (RDBMS)

Important Questions

Unit -1
Long
1. What is File system? Write the disadvantages of File system?
2. What is DBMS? Write the advantages of DBMS?
3. DBA role and functions.
4. Explain ER model with the help of diagram?

Short
1. DBMS
2. Primary key, Foreign key, candidate key and super key
3. Write relational algebra functions
4. Weak and strong entity
5. Specialization, Generalization and Aggregation

Unit – 2
Long
1. What is Normalization? Explain all Normal Forms with examples.
2. What is File Organization? Explain its types.
3. What are Indexes in DBMS? Explain the different types of indexes.

Short
1. Entity integrity constraints
2. Functional dependency
3. Decomposition
4. Binary search tree.

Unit – 3
Long
1. What is SQL? Explain DDL and DML commands with examples.
2. Explain all SQL Data Types with examples.
3. Write and explain different SQL Queries.

Short
1. Operators in SQL
2. Where clause
3. Group by and having clause
4. Types of Joins

Unit – 4
Long
1. Write about ACID Properties.
2. Explain about Two – Phase Locking Protocol.
3. What is a Deadlock? Explain Deadlock Prevention Techniques.
4. What is Database Recovery? Explain its techniques.

Unit – 5
Long
1. What is a Distributed Database Management System (DDBMS)? Explain its
advantages and disadvantages.
2. Explain Client-Server Database Architecture: 2-Tier and 3-Tier Models.
3. What is Data Fragmentation in DBMS? Explain its types.
4. Explain OLTP (Online Transaction Processing) and OLAP (Online Analytical
Processing)
and their differences.

Short
1. Define Data warehouse
2. Mobile database
3. Define Data replication
4. Database partition

You might also like