DR. BABASAHEB AMBEDKAR TECHNOLOGICAL UNIVERSITY, LONERE
Mid Semester Examination – Sem 2019
Course: B. Tech in Information and Technology
--- Content provided by FirstRanker.com ---
Subject Name: Database Management System
Sem: V
Date: 18/09/2019
Subject Code: BTITC501
Duration:-1 Hr.
--- Content provided by FirstRanker.com ---
Max Marks: 20
Instructions to the Students:
- Assume suitable data wherever necessary.
Q.1 Attempt all from following.
| (Level/CO) | Marks |
|---|---|
| CO2 | 6 |
A Type of query that is placed within a WHERE or HAVING clause of another query is called
--- Content provided by FirstRanker.com ---
a) Master query b) Sub query c) Super query d) Multi-query
B The language used by application programs to request data from the DBMS is referred to as
a) DML b) DDL c) Query language d) All of the Mentioned
C Cartesian product in relational algebra is
a) Unary operator. b) Binary operator. c) Ternary operator d) not defined.
--- Content provided by FirstRanker.com ---
D The operation of a relation X, produces Y, such that Y contains only selected attributes of X. Such an operation is
a) Projection b) selection c) Intersection d) union
E Relational algebra is
a) DDL b) DML c) TCL d) Procedural query language
F Which of the following is not a valid binary operation in the relational algebra ?
--- Content provided by FirstRanker.com ---
a) project b) union c) set difference d) Cartesian product
Q.2 Attempt any two from following 3X2
(A) Explain DDL, DML and TCL commands with suitable example CO1
(B) Attempt following CO1
- Add an attribute named 'Designation' to the table 'Emp'.
- Modify the table 'Emp', Change the datatype of 'salary' attribute to double.
- Drop the attribute 'depttname' from the table 'emp'.
--- Content provided by FirstRanker.com ---
(C) Explain different users of database approach CO1
Q.3 Attempt following queries CO3 8X1
(A) Attempt any 4 sql queries for following.
--- Content provided by FirstRanker.com ---
Employee(e_name, street, city)
Works(e_name, c_name, sal)
Company(c_name, city)
Manages(e_name, manager_name, city)
a) Find names of all employees who works for wipro and earn more than 10000
--- Content provided by FirstRanker.com ---
b) Find company name which is located in same city as that of wipro (assume wipro is located at multiple location)
c) Find company name that has most number of employees
d) Find names of employee who earns more than wipro employee
e) Find name of employee who lives in same city as Remesh.
f) Find name of employee who earns more than average salary of wipro employee
--- Content provided by FirstRanker.com ---
*** End ***
Download More @ FirstRanker.com
This download link is referred from the post: DBATU B-Tech Last 10 Years 2010-2020 Previous Question Papers || Dr. Babasaheb Ambedkar Technological University
--- Content provided by FirstRanker.com ---