JNTUH MCA 3rd Sem Last 10 Years 2023-2013 Question Papers R20-R09 || Jawaharlal nehru technological university
FirstRanker.com
Firstranker's choice
FirstRanker.com
FirstRanker.com
R17
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
MCA III Semester Examinations, April/May - 2019
DATABASE MANAGEMENT SYSTEMS
Note: This question contains two parts A and B.
Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 10 marks and may have a, b, c as sub questions.
PART - A 5 x 5 Marks =25
1. a) Discuss about different types of database users. [5]
3. a) What is functional dependency? Explain with an example. [5]
4. What is a transaction? What are the properties of transaction? [5+5]
5. What are sparse and dense indexes? [5]
PART -B 5 x 10 Marks =50
OR
7. Explain about database system architecture. [10]
8. Discuss about various data models. [10]
OR
10. OR
a) Discuss about destroying and altering tables and views. [5+5]
11. Explain in detail about nested queries. [10]
12. Discuss about different types of relational calculus in detail. [10]
13. Explain 3 NF and BCNF with examples. [10]
14. Explain timestamp based protocols. [10]
OR
15. Explain ARIES recovery system. [10]
17. Explain about cluster index. [10]
OR
18. Explain about different file organizations. [10]
---00000---
Firstranker's choice
FirstRanker.com
--- Content provided by FirstRanker.com ---
Code No: 843AAFirstRanker.com
R17
--- Content provided by FirstRanker.com ---
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
MCA III Semester Examinations, April/May - 2019
DATABASE MANAGEMENT SYSTEMS
--- Content provided by FirstRanker.com ---
Time: 3hrs Max.Marks:75Note: This question contains two parts A and B.
Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 10 marks and may have a, b, c as sub questions.
PART - A 5 x 5 Marks =25
1. a) Discuss about different types of database users. [5]
--- Content provided by FirstRanker.com ---
2. b) When can we use group by clause? Explain with an example. [5]3. a) What is functional dependency? Explain with an example. [5]
4. What is a transaction? What are the properties of transaction? [5+5]
5. What are sparse and dense indexes? [5]
PART -B 5 x 10 Marks =50
--- Content provided by FirstRanker.com ---
6. What is the role of storage manager? Explain. [10]OR
7. Explain about database system architecture. [10]
8. Discuss about various data models. [10]
OR
--- Content provided by FirstRanker.com ---
9. Discuss about integrity constraints over relations. [10]10. OR
a) Discuss about destroying and altering tables and views. [5+5]
11. Explain in detail about nested queries. [10]
12. Discuss about different types of relational calculus in detail. [10]
--- Content provided by FirstRanker.com ---
OR13. Explain 3 NF and BCNF with examples. [10]
14. Explain timestamp based protocols. [10]
OR
15. Explain ARIES recovery system. [10]
--- Content provided by FirstRanker.com ---
16. Explain ISAM in detail. [10]17. Explain about cluster index. [10]
OR
18. Explain about different file organizations. [10]
---00000---
--- Content provided by FirstRanker.com ---
FirstRanker.comThis download link is referred from the post: JNTUH MCA 3rd Sem Last 10 Years 2023-2013 Question Papers R20-R09 || Jawaharlal nehru technological university
--- Content provided by FirstRanker.com ---