[go: up one dir, main page]
Scribd
Upload
676 views2 pages

Dbms Question Bank Unit I

The document contains questions about database management systems (DBMS) across 5 units. The questions cover topics such as data modeling, relational algebra, normalization, transaction management, concurrency control, recovery techniques, and indexing structures.

Uploaded by

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

Dbms Question Bank Unit I

The document contains questions about database management systems (DBMS) across 5 units. The questions cover topics such as data modeling, relational algebra, normalization, transaction management, concurrency control, recovery techniques, and indexing structures.

Uploaded by

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

DBMS QUESTION BANK

Unit I
1. What is a data model? What are the different data models? Explain relational and object based
model?
2. Explain database users, user interfaces and role of DBA?
3. Explain the following:
i) Data Abstraction ii) Instances and Schemas iii) Data Models
4. Illustrate the disadvantages of file processing system?
5. Develop ER Diagram for a hospital with a set of patients and a set of medical doctors. Associated
with each patient a log of the various tests and examinations conducted.
6. Discuss in detail the database system structure with a neat diagram?
7. Construct and ER diagram for an online shopping systems such as Jabong/Flipkart. Quote your
assumptions and list the requirements consider by you for conceptual database design for the
above system.
8. Explain in detail about the use of entity sets versus relationship sets with an example.
9. How to specify different mapping cardinalities in ER diagram? Give examples.
10. What are the main components in a DBMS and briefly explain what they do.
11. What is relation? Differentiate between a relation schema and relation instance? Define the term
arity and degree of a relation? What are domain constraints?
12. State and explain various features of E-R models.
Unit II
1. What is the significance of integrity constraints? Explain with examples?
2. Define the terms: cardinality, relation, relation schema, relation instance
3. What is meant by compound condition in SQL? How do you enter one in a SQL query?
4. Explain the following operators in SQL with examples:
i) IN ii) All iii) Except iv) Order by
5. What are integrity constraints? Define the terms primary key constraints and foreign key
constraints? How are these expressed in SQL?
6. What are the aggregate and comparison operators in SQL? Explain with an example in detail?
7. What is the usage of group by and having clauses in SQL? Explain with example?
8. How do you use join tables in SQL? Illustrate all types of join in SQL?
9. Discuss the set operations with examples?
Unit - III
1. Define BCNF and 3NF. What are the benefits of BCNF and 3NF?
2. Explain the fundamental operations in relational algebra with examples?
3. Discuss the additional relational-algebra operations with examples?
4. Explain the concept of tuple relational calculus?
5. Discuss the extended relational-algebra operations with examples?
6. Discuss about domain relational calculus?
7. How the database can be modified using relational algebra?
8. Where does normalization fit in the process of database design?
9. What is normalization? What are the conditions required for a relation to be in 2NF, 3NF and
BCNF?
10. Compute the closure of the following set of functional dependencies for a relation scheme.
R(A,B,C,D,E)
F={A->BC, CD->E, B->D, E->A}
List out the candidate keys of R.
11. What are the conditions required for a relation to be in 4NF and 5NF? Explain with examples?
12. What is meant by functional dependencies? Differentiate FD with MVD?
13. Explain the problems related to decomposition?
14. What is meant by closure of F? Explain its axioms with the necessary rules?
Unit IV
1. How a data item has been locked? Illustrate the implementation of locks in transaction?
2. Explain about locking protocols and serializability?
3. Explain two phase commit protocol and concurrency concepts in transactions?
4. Discuss about multiple granularity?
5. Describe the steps in crash recovery in ARIES.
6. Explain the two phase locking protocol in a schedule of transaction?
7. What is transaction? Explain the ACID properties of a transaction?
8. Explain the timestamp-based protocols for controlling the concurrency?
9. Explain the transaction states and its desirable properties?
10. How to test seriablizability of a schedule? Explain with an example?
11. Describe the passes through which ARIES recovers from a system crash?
12. Explain the log-based recovery scheme for recovering the database?
13. Discuss in detail about the architecture of remote backup system?
Unit V
1. What is the minimum space utilization for a B+ tree & ISAM index?
2. How to organize data entries using indexing? Discuss.
3. Explain deletion and insertion operations in ISAM with examples.
4. Explain deletion and insertion operation in B+ trees.
5. Discuss in details the ISAM index structure?
6. Explain all the operations of B+ tree for indexing with suitable examples?

You might also like