B.Tech Database Management Systems (DBMS) Previous year Questions

Hello, In this post I am going to frame some trending questions on Data Base Management System Previous Questions asked in JNTU External Examinations. Hope the questions will remind you untill your performance.

JNTUA R15 PREVIOUS QUESTION PAPERS :

1. What is meta data? Explain with example.
2. Differentiate between external model and internal model.
3. What is a key? Explain various types of keys.
4. Explain briefly about one to one, one to many and many to many relations.
5. How the relationships within the relational database are established? Explain each with example.
6. Explain about all the SQL functions in advanced SQL with syntax and example.
7. Explain join dependency.
8. Explain 5NF with an example.
9. Explain about : Scheduler
   Uncommitted data.
   Inconsistent retrieval.
   Lost updates.
10. Describe in detail about buffer management in recovery system.
11. What is log based buffering and database buffering? Explain.
    Briefly explain about index selectivity.
    (a)  Explain the transaction management in database.
12. Discuss the query processor of database system structure.
13. Distinguish between procedural and non-procedural DML’s.
14. Define relational algebra, tuple and domain relational calculus.
15. What are the differences between the two types of relational calculus?
16. What is dependency preservation property for decomposition? Explain why it is important.
17. Define BCNF. How does BCNF differ from 3NF? Explain with an example.
18. Explain 3nf. Give one example.
19. What are the lists of actions transaction can perform on a database objects? Explain with suitable schedule.
20. What are the transaction isolation levels in SQL?
21. What are the merits & demerits of using fuzzy dumps for media recovery?
22. Explain the phases of ARIES algorithm.
23. Explain 3 main properties of ARIES algorithm.
24. Give an example of a database application in which the reserved-space method of representing variable - length records is preferable to the pointer method. Explain.
25. What are the causes of bucket overflow in a hash file organization? What can be done to reduce the occurrence of bucket overflows?