ADB
15 Marks
Question Bank
1. Explain the overall structure of DBMS.
2. Discuss the ER modeling concepts with a neat sketch.
3. Explain the various database languages.
4. Write in detail about SQL.
5. Explain the Normalization in detail.
6. Explain heuristic optimization algorithm for query processing.
7. Explain the steps involved in Query Optimization.
8. Explain the locking methods of Concurrency control.
9. Discuss the various techniques to ensure database security.
10. Explain the various Recovery techniques of Database Recovery Systems.
11. Explain the types of Database Recovery.
12. Explain Query Parallelism.
13. Explain the key elements of Parallel database processing.
14. Explain the architecture of Parallel database systems.
15. Explain distributed database system design.
16. Explain architecture of distributed database.
17. Explain the recovery control in distributed database.
18. Explain database warehouse architecture.
19. Explain data mining and knowledge discovery.
20. Discuss emerging trends in database technology.
5 Marks
1. Explain the functions of a DBA.
2. Discuss the various data models.
3. Explain the structure of a relational database.
4. What are the problems with ER models?
5. Explain specialization and generalization.
6. Explain functional dependency and decomposition.
7. Explain the purpose of syntax analyzer.
8. Explain the stages of query decomposer.
9. Explain cost estimation in query optimization.
10. Explain the structure of query evaluation plan.
11. What are the problems of concurrency control?
12. What are the different locking levels?
13. Explain deadlock in database systems.
14. What are the types of database failures?
15. Explain check points.
16. What are the threats to database security?
17. Explain statistical database security.
18. Discuss data encyption.
19. List the advantages and disadvantages of parallel database.
20. What are the types of distributed database?
21. Give the merits and demerits of distributed database.
22. Explain data fragmentation.
23. Give the characteristics ,benefits and limitations of data warehouses.
24. Discuss OLAP.
25. Explain digital libraries.
26. Explain spatial databases.
27. Explain web and multimedia databases.
28. Explain mobile databases.
