Fresher Jobs

Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian cities including Bangalore, Chennai, Hyderabad, Pune or Kochi

Resources

Find educational articles, blogs, discussion threads and other resources.

Colleges

Find details about any college in India or search for courses.

Download Model question papers & previous years question papers

Posted Date: 01 Aug 2009 Posted By: Sunil Reddy Member Level: Platinum

2009 Jawaharlal Nehru Technological University Jntu Hyderabad, Code No: 07A4EC14 Set No.2 II B.Tech II Semester Regular Examinations, Apr/May 2009 DATA BASE MANAGEMENT SYSTEMS ( Common to Computer Science & Engineering and Information Technology) Question paper

Course: B.Tech Information Technology

University: Jawaharlal Nehru Technological University

Code No: 07A4EC14 Set No. 2
II B.Tech II Semester Regular Examinations, Apr/May 2009
DATA BASE MANAGEMENT SYSTEMS
( Common to Computer Science & Engineering and Information
Technology)
Time: 3 hours Max Marks: 80
Answer any FIVE Questions
All Questions carry equal marks
? ? ? ? ?
1. (a) Explain the Transaction management in a database.
(b) Discuss the Query Processor of Database system structure. [8+8]
2. (a) What is a relational database query? Explain with an example.
(b) What are the SQL constructs to modify the structure of tables, views and to
destroy the tables and views? [8+8]
3. (a) Define query processing and briefly explain the steps involved in it?
(b) Write queries for the following using the given information
Emp Name DOB DOJ Emp Salary Bonus DOR
Buelin 06-12-1983 07-08-2005 15000 600 07-08-2055
Andy 12-01-1970 06-12-1973 20000 1200 06-12-2043
Lubber 07-08-1985 12-04-2006 13000 500 12-04-2056
Zobra 08-02-1960 07-03-1982 25000 1500 07-03-2032
(a) Find total salary of employees from emptable?
(b) Find months between employee DOJ and DOR from emp-schema?
(c) Create new salary table using the ampno, empname, and empsalary from
existing table?
(d) Arrange empnames in ascending and descending order? [16]
4. (a) Define BCNF. How does BCNF differ from 3NF? Explain with an example.
(b) Explain 3nf? Give one example? [8+8]
5. (a) Define the concept of schedule for a set of concurrent transaction. Give a
suitable example. [8]
(b) Explain read-only, write-only & read-before-write protocols in serialazability.
[8]
6. (a) What are the types of failures of a system. [6]
(b) What are the reasons strict 2PL used in many database systems [5]
(c) How the use of 2PL would prevent interference between the two transactions.
[5]
7. (a) Explain about Fixed-Length Representation in detail.(b) Explain about Byte-String Representation. in detail. [8+8]
8. Explain about the B -tree and the structure of B + tree in detail with an example
(b) Explain about Byte-String Representation. in detail. [8+8]
8. Explain about the B -tree and the structure of B + tree in detail with an example

Return to question paper search

Next Question Paper: Jntu Hyderabad, Code No: 07A4EC14 Set No. 1 II B.Tech II Semester Regular Examinations, Apr/May 2009 DATA BASE MANAGEMENT SYSTEMS ( Common to Computer Science & Engineering and Information Technology)

Previous Question Paper: Jntu Hyderabad, Code No: 07A4EC14 Set No.3 II B.Tech II Semester Regular Examinations, Apr/May 2009 DATA BASE MANAGEMENT SYSTEMS ( Common to Computer Science & Engineering and Information Technology)