Database Management System (AD-402) - Important Questions

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

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

What do mean by generalization, aggregation and specialization.

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

Write short notes on Schemas and Instances, Triggers, Query Optimization, and Serializability.

Define the following.

Explain in detail the responsibilities of a Database Administrator (DBA).

Write the differences between Database approach v/s Traditional file accessing approach.

Differentiate between conceptual, logical, and physical schemas.

Discuss the suitability of each, object-oriented, network and relational data models for different types of applications.

List and explain the advantages of DBMS.

Explain relational algebra and its basic operations in DBMS

Explain the concept of SQL command with suitable example.

Compute the Cartesian product of given relations P and Q

Define primary key and foreign key constraint and how these constraints are expressed in SQL?

Describe tuple relational calculus with a suitable example.

Write short notes on relational algebra and calculus, Select-Project-Join operations, concurrency control, data dictionary and dynamic performance views

Define a relational database schema. Discuss the components of a schema, including tables, attributes, and relationships.

Explain the difference between intension and extension using examples.

Compare and contrast tuple-oriented and domain-oriented relational calculus.

Discuss the usage of 'group by' and 'having' clauses in SQL.

Explain division operation in relational algebra with a suitable example.

List and explain the properties of relational algebra

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

Explain the technique join optimization techniques with proper example.

Normalize a given relation with functional dependencies up to 3NF.

What is Boyce-Codd Normal Form (BCNF)? Explain with an example.

Illustrate insertion, deletion and modification anomalies with suitable examples.

Determine whether two given sets of functional dependencies are equivalent.

What is normalization? Explain 4NF with an example.

Explain the objectives of normalization, such as minimizing redundancy and dependency preservation.

Illustrate functional dependencies in relational databases with examples.

Define the closure of a set of functional dependencies $F$ and explain how to compute $F^+$ with examples.

Discuss the conditions for a relation to be in 1NF and 2NF with a suitable example.

List and explain the steps for optimizing the Query.

Discuss the concept of concurrency control in a database system.

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

Explain the Two-Phase Locking (2PL) protocol for concurrency control.

Compare and differentiate OODBMS vs DBMS, including strengths and weaknesses in different scenarios.

How does the granularity of data items affect the performance of concurrency control? Explain.

Write the advantages and disadvantages of validation protocol.

Illustrate a timestamp-ordered schedule for two transactions transferring amount from A to B with given timestamps.

Explain locking techniques for concurrency control including shared locks, exclusive locks, and deadlock detection and prevention.

Discuss the challenges associated with distributed database management, such as data fragmentation, replication, and distributed transaction management.

Explain the timestamp-based concurrency control protocol in detail.

Discuss the procedure to test serializability of a schedule with an example.

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

What is the data dictionary in DBMS ? Explain its type.

Write SQL queries using INNER JOIN and LEFT JOIN.

Explain RDBMS architecture with all components.

What are the key characteristics of ANSI SQL? Explain in detail.

Discuss the usage of special operators such as LIKE, ANY, ALL, EXISTS, and IN in SQL queries.

Explain the procedure for data extraction from single and multiple tables.

Discuss in detail stored procedures.

Explain in brief any two of the following: