Jawaharlal Nehru Technological University Anantapur 2009 B.Tech Electronics and Communications Engineering ece - Question Paper
ece
Code No: 37139 SET-1
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD R05 IV B.Tech. I Semester Supplementary Exams, May/June - 2009 DATA BASE MANAGEMENT SYSTEMS (Common to ECE, EIE, E.CON.E, ETM, & ECC)
Time: 3 hours Max Marks: 80
Answer any FIVE Questions.
All Questions carries equal marks.
1. Explain briefly about V arious Data Models with examples. [16]
2. Write about Various Relational Algebraic operations. [16]
3. Discuss about the following concepts in SQL with examples.
a. Aggregative operators.
b. Logical connectivitys . [16]
4. What is the need for Normalization? Explain 1NF and 2NF. [16]
5. Explain about Transaction Management. [16]
6. Discuss about the following concepts.
a. Serializability.
b. Recoverability. [16]
7. Write briefly about Primary and secondary Indexes. [16]
8. Explain the concepts of RAID Technology. [16]
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD R05 IV B.Tech. I Semester Supplementary Exams, May/June - 2009 DATA BASE MANAGEMENT SYSTEMS (Common to ECE, EIE, E.CON.E, ETM, & ECC)
Time: 3 hours Max Marks: 80
Answer any FIVE Questions.
All Questions carries equal marks.
1. Explain briefly about various Database Languages. [16]
2. Discuss about Relational Model with an Example. [16]
3. Discuss about the following concepts in SQL with examples.
a. Nested queries.
b. Comparison operators. [8+8]
4. Explain the concepts of 3NF and BCNF with examples. [16]
5. Explain about ACID properties of a Transaction. [16]
6. Discuss about the following concepts.
a. Deadlocks.
b. Crash recovery. [8+8]
7. Write briefly about Cluster and Primary Indexes. [16]
8. Explain B+ Trees with examples. [16]
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD R05 IV B.Tech. I Semester Supplementary Exams, May/June - 2009 DATA BASE MANAGEMENT SYSTEMS (Common to ECE, EIE, E.CON.E, ETM, & ECC)
Time: 3 hours Max Marks: 80
Answer any FIVE Questions.
All Questions carries equal marks.
1. Explain briefly about the following.
a. Database Users.
b. Transactin Management. [8+8]
2. Explain briefly about Relational calculus. [16]
3. Discuss about the following concepts in SQL with examples.
a. Aggregative operators.
b. Logical connectivitys . [8+8]
4. Write about Multi valued Dependency with suitable example. [16]
5. Explain about Lock Based Concurrency control. [16]
6. What is a Deadlock and how they are handled in DBMS? [16]
7. Write briefly about Cluster and Primary Indexes. [16]
8. Explain Briefly about Dynamic Hashing with an example. [16]
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD R05 IV B.Tech. I Semester Supplementary Exams, May/June - 2009 DATA BASE MANAGEMENT SYSTEMS (Common to ECE, EIE, E.CON.E, ETM, & ECC)
Time: 3 hours Max Marks: 80
Answer any FIVE Questions.
All Questions carries equal marks.
1. Explain about ER-Model and Additional features of ER-Model with examples.
[16]
2. Explain about the following:
a. Views and Tables
b. Enforcing Integrity constraints. [8+8]
3. Discuss about the following concepts in SQL with examples.
a. Aggregative operators.
b. Null values and Comparison using Null values. [8+8]
4. What is schema refinement and explain 1NF, 2NF and 3NF. [16]
5. Explain briefly about ACID properties of a Transaction. [16]
6. Explain about Concurrency concepts of DBMS. [16]
7. Write briefly about Primary and secondary Indexes. [16]
8. Explain about Space management and Buffer management. [16]
--OoO--
|
Attachment: |
| Earning: Approval pending. |
