CS2255 Database Management Systems Important Questions

1. Draw on E-R diagram for

 Banking

 Library Management

2. Describe the structure of the database system

3. Mention any four responsibilities of DBA

4. Discuss about different types of data models with neat diagram

5. Explain tuples & Domain relational calculus with an example

6. Discuss the following in SQL with examples

 Data Manipulation, Data Definition, Data control Languages & views

7. Explain nested queries with an example

8. Explain the nested security features provided in commercial query language

9. With relevant examples discuss first, second, third normal form and BCNF

10. Discuss Boyce-codd normal form with an example

11. Discuss join dependencies and fifth normal forms and explain why 5NF?

12. Explain the log based recovery techniques

13. State two phase commitz protocols discuss the implications of a failure of the coordinator

and some participants

14. Explain

 Shadow paging

 Deadlock

 Serializability

15. Discuss the various recovery mechanisms in DBMS

16. How can you implement atomicity in transaction? Explain

17. Mention the purpose of indexing. How this can be done by B+ tree Explain

18. Describe the different types of file organization? Explain with diagram?

19. Describe in detail about RAID

20. Discuss the steps involved in processing a query

About Admin AU-Zone

We are a community of students and proffessors striving hard to bridge the gap between Students and Anna university. We provide all types of information related with Anna University and we also help students with their Exam Preparations.