JNTU Exam Papers B.Tech 3rd Year Database Management System June 2007

IV B.Tech II Semester Supplementary Examinations, June 2007 DATA BASE MANAGEMENT SYSTEMS SET-IV 1. Explain the different types of integrity constraints with suitable examples. 2. (a) Consider the following schema given. The primary keys are underlined. Sailors(sailor-id, sailor-name, sailor-rating, sailor-age) Boats(boat-id, boat-name, boat-color) Reserves(sailor-id, boat-id, day) Write the Nested queries in SQL. i. Find the … Read more JNTU Exam Papers B.Tech 3rd Year Database Management System June 2007

JNTU Previous Question Papers B Tech III Database Management System June 2007

┬áB.Tech III Semester June 2007 DATA BASE MANAGEMENT SYSTEMS SET-III 1. (a) What is a Data model ? List the important data models (b) Explain i. DDL ii. DML iii. Data sublanguage iv. Host language 2. (a) what are the various salient features of the QBE ? (b) Explain the following : i. Relational database … Read more JNTU Previous Question Papers B Tech III Database Management System June 2007

JNTU Previous Exam Papers B.Tech III Year Semester Database Management System June 2007

IV B.Tech II Semester Supplementary Examinations, June 2007 DATA BASE MANAGEMENT SYSTEMS SET-II 1. (a) What is outer join ? What are its advantages over natural join ? Give an example. (b) What is a domain constraint? Explain with an example. 2. (a) Discuss the various DDL, DML commands with illustrations in SQL. (b) Why … Read more JNTU Previous Exam Papers B.Tech III Year Semester Database Management System June 2007

JNTU Exam Papers,IV B.Tech II Semester Supplimentary Examinations, Database Management Systems, June 2007

IV B.Tech II Semester Supplementary Examinations, June 2007 DATA BASE MANAGEMENT SYSTEMS SET-I 1. List and explain the various operations of Relational algebra. 2. (a) Consider the following schema Employee (employee-name, street, city) Works (employee-name, company-name, salary) Company (Company-name, city) Managers ( employee-name, manager-name) Write the following queries in SQL . i. Find the names … Read more JNTU Exam Papers,IV B.Tech II Semester Supplimentary Examinations, Database Management Systems, June 2007