Database Management System (AD-402) - Important Questions

Explain the architecture of a typical DBMS with a neat diagram.

Define Database Administrator (DBA) and describe the types of Database Administrator.

Explain relational algebra and its basic operations in DBMS with suitable examples.

Define primary key and foreign key constraints and explain how these constraints are expressed in SQL with examples.

Explain multivalued dependency and Fourth Normal Form (4NF) with suitable examples.

Consider the relation STUDENT(SID, Name, Course, Faculty, Faculty Phone) with functional dependencies SID -> Name, Course; Course -> Faculty; Faculty -> Faculty Phone. Normalize the relation up to 3NF.

Discuss the concept of concurrency control in a database system, its need and objectives.

Explain the Two-Phase Locking (2PL) protocol for concurrency control with its types and limitations.

Explain the concept of NoSQL databases and compare their features, characteristics, advantages, limitations and applications with traditional RDBMS.

Write SQL queries using INNER JOIN and LEFT JOIN with suitable examples from single and multiple tables.

Explain the features and components of the E-R model including entity, attributes, entity sets, relationship types and keys with examples.

Describe tuple relational calculus with a suitable example.

Write the differences between database approach versus traditional file accessing approach.

Illustrate functional dependencies in relational databases with examples and explain insertion, deletion and modification anomalies caused by them.

Write short notes on schemas and instances, explaining their types with examples.

Discuss the database recovery process and explain how checkpoints and log files help restore the database after system failures or transaction crashes.