Important Qns DBDM

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 1

Part A

1. Differentiate between stored and derived attributes.


2. Describe the entity-relationship model and its components.
3. Identify the main properties of transactions in databases.
4. Explain the concept of atomicity with examples.
5. Illustrate the various transaction states
6. Define and examine the concept of serializability in transactions
7. Compare SQL and NoSQL databases
8. Summarize the CAP theorem principles
9. Distinguish between different MongoDB CRUD operations.
10. Outline the functions of CRUD operations.

Part B

1. Explain the concept of functional dependencies in a database schema and


discuss their significance.
2. Describe the process of normalization and outline the steps for 1NF, 2NF,
3NF, and BCNF.
3. Summarize the key concepts and states in transaction management within
databases.
4. Explain why recovery mechanisms are essential in databases, and discuss
two common recovery techniques.
5. Apply the concept of serializability in databases and explain its types with
examples.
6. i) Apply concurrency control mechanisms in database operations.
ii) Discuss the two-phase locking protocol and discuss its advantages.
7. Apply the principles of CAP theorem to explain its components and their
impact on distributed databases.
8. Demonstrate how HBase is used in database management by describing its
basic concepts, purpose, and practical use cases
9. Explain the CRUD operations in HBase and their significance in database
management.
10. Summarize the CRUD operations in MongoDB, focusing on their use and
importance
Part C
1. Construct RAID systems and Explain how the improve performance and reliability
2. Illustrate the use of NoSQL databases by explaining their core concepts
and discussing examples of their applications in real-world scenarios
3. Identify the SQL Injection Methods with an example.

You might also like