DBMS Important Questions All Units
UNIT - I
1. What are the applications of Database systems.
2. What is the uses of Databases.
3. Database Architecture.
4. Various Database Users.
5. Role of a DBA. (Database Administrator)
6. Relational Query Languages.
7. What is ER-Diagram? Importance of ER diagram.
8. Draw the ER-Diagram for ( Library Management System, Banking system, University Database,
Online shopping or e-commenrce)
UNIT - II
9. Database Languages. (DDL, DML, TCL , DCL , and queries on these languages)
10. Write about Aggregate functions.
11. Nested Queries / Sub Queries.
12. What is Relational Algebra and Relational Calculus.
13. Queries using Relational Algebra and Relational Calculus.
UNIT - III
14. What is Normalization. Explain various Normal Forms.
15. Or Explain 1NF, 2NF, 3NF, BCNF (4NF and 5NF optional)
16. What is Functional Dependency ? Explain with example.
17. What is a Decomposition. Explain different types of Decomposition. (Lossy AND Loseless)
18. Differentiate 3NF and BCNF.
19. What is a Transaction? Explain various Transaction States.
20. What is Serializability. Explain .
UNIT – IV
1. Transaction Management, Transaction states.
2. ACID Properties.
3. Recoverability and Recovarable Schedule.
4. Serializability & Types.
5. Validation Based protocol.
6. Timestamp Based protocol, 2 Phase Lock Control Protocol. (2PL)
7. Fixed and Variable Length records.
8. ARIES Algo. And its Data Structure.
UNIT – V
9. Sequential File accessing Techniques.
10. Data Dictionary.
Remote Backup Sys.
11. B+ Tree construction.
12. Hashing techniques.
13. Bitmap indexing technique.
