07A70307 Data Base Management Systems B.Tech Question Paper : scce.ac.in
Name of the College : SREE CHAITANYA COLLEGE OF ENGINEERING
University : JNTUH
Department : Mechanical Engineering
Subject Code/Name : 07A70307/DATA BASE MANAGEMENT SYSTEMS
Year/Sem : IV/I
Website : scce.ac.in
Document Type : Model Question Paper
Download Model/Sample Question Paper : https://www.pdfquestion.in/uploads/scce.ac.in/4913-07A70307-DATABASEMANAGEMENTSYSTEMS.pdf
SCCE DBMS Question Paper
Code No: 07A70307
R07
Set No. 1
IV B.Tech I Semester Examinations,December 2011
Related : Sree Chaitanya College Of Engineering 09A1EC01 Computer Programming & Data Structures B.Tech Question Paper : www.pdfquestion.in/4884.html
Common to Mechanical Engineering, Electronics And Computer Engineering, Electronics And Telematics, Electronics And Communication Engineering
Time : 3 hours
Max Marks: 80
Answer any FIVE Questions :
All Questions carry equal marks :
1. (a) Briefly discuss about locks and lock management in DBMS.
(b) Explain recoverability in transactions in detail. [8+8]
2. What is redundancy? Explain the dierent problems encountered by redundancy. [16]
3. (a) What are five main functions of a database administrator? Explain.
(b) List seven programming languages that are procedural and two that are nonprocedural. Which group is easier to learn and use? Explain your answer. [8+8]
4. Consider the relational database given below,
employee (person-name, street, city)
works (person-name , company-name, salary)
company (company-name, city)
manages (person-name, manager-name )
where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries:
(a) Find the names of all employees who work for First Bank Corporation.
(b) Find the names and cities of residence of all employees who work for First Bank Corporation.
(c) Find the names, street address, and cities of residence of all employees who work for First Bank Corporation and earn more than $10,000 per annum.
(d) Find the names of all employees in this database who live in the same city as the company for which they work. [16]
5. Consider the employee database given below
employee (employee-name, street, city)
works (employee-name, company-name, salary)
company (company-name, city)
manages (employee-name, manager-name),
Give an expression in SQL for each of the following queries
(a) Modify the database so that Jones now lives in Newtown.
(c) Give all managers of First Bank Corporation a 10 percent raise.
(d) Give all managers of First Bank Corporation a 10 percent raise unless the salary becomes greater than $100,000; in such cases, give only a 3 percent raise. [4+4+4+4]
6. (a) Briefly discuss about static index structure.
(b) Explain file organizations. [8+8]
7. Design a generalization – specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles, passenger cars, vans, and buses. Justify your place- ment of attributes at each level of the hierarchy. Explain why they should not be placed at a higher or lower level. [16]
8. ARIES assumes there is space in each page for an LSN. When dealing with large objects that span multiple pages, such as operating system files, an entire page may be used by an object, leaving no space for the LSN. Suggest a technique to handle such a situation; your technique must support physical redos but need not support physiological redos. [16]
Set No. 2
Code No: 07A70307
R07
1. (a) Explain alternatives in decomposition in BCNF.
(b) Explain the relationship between BCNF and Dependency preservation. [8+8]
2. (a) Explain concurrent executions of transactions in DBMS.
(b) What are timestamp-based protocols? Explain. [8+8]
3. Explain the following in SQL with examples.
(a) Nested Queries
(b) Correlated Queries
(c) Group by and Having Clauses
(d) Triggers [4+4+4+4]
4. (a) Explain about various binary operations with examples in relational algebra.
(b) What is a domain constraint? Explain with an example. [8+8]
5. Describe how search, insert, and delete operations work in ISAM indexes. Discuss the need for over flow pages, and their potential impact on performance. What kinds of update workloads are ISAM indexes most vulnerable to, and what kinds of workable do they handle well? [16]
6. (a) Explain the dierence between a weak and a strong entity set.
(b) Define the concept of aggregation. Give two examples of where this concept is useful. [8+8]
7. (a) List out the Database system applications.
(b) Write briefly about instances and schemas. [8+8]
8. For each of the following requirements, identify the best choice of degree of durability in a remote backup system:
(a) Data loss must be avoided but some loss of availability may be tolerated.
(b) Transaction commit must be accomplished quickly, even at the cost of loss of some committed transactions in a disaster.
(c) A high degree of availability and durability is required, but a longer running time for the transaction commit protocol is acceptable. [16]