Download DBATU B.Tech 2019 Oct-Nov IT 5th Sem Database Management System Question Paper

Download DBATU (Dr. Babasaheb Ambedkar Technological University) B Tech 2019 Oct-Nov (Bachelor of Technology) IT 5th Sem Database Management System Question Paper

R TECHNOLOGICAL UNIVERSITY, LONERE '
Mid Semester Examination? Sop ?019
? Course: B Tech' 111 Information and Technology Sem?: V
Subject Name: Database Management System Subject Code: BTITCSOI
Max Marks: 20: 1 Date:'-, 18] 1121 Jim 9 Duration:- 1 Hr.
Instructions to the Students:
1. ASSume suitable (111111 wherever necessary;
(Level/CO)
Marks
Attempt all from following ?
Type of query that 15 placed within a W HERE or HAVING clause of another query is
called
a) Master queryb) Sub query c)Supe1 query d)'Multi-q11ery
C02
' The language used application programs to request data from the DBMS is referred to as
a) DML b) DDL c) Query language d) All of the Mentioned ?
C02
Cartesian product in relational algelira is
a) Unary operator. b) 'Binary operator; 0) Ternary operator d)notvde?ned.
C02
The operation of a relation X, produces Y, suchthatY contains} -s1ly selected
attribtitcs of X. Such an Operaumi is
a)Projec1io11 b)selcctio11? c)l11tersection d)u11io11
C-OZ
Relational aigebra is
a) DDL b) DML c) TCL d) Procedural query language
C02
Which of the following 15 not a valid binary operation in the relat: onal algebra ?
a)project b)union 0) set difference d) Cartesian product
C02
(2.2
Attempt any two from following
3X2
(A)?
Explain DDL, DML and TCL commands with suitable exam ple
C01
(B) '
Attempt follOwing
1. Add an attribute named? Designation' to the table ?F mp
2. Modify the table ?Emp?, Change the datatypc of? salary? attribute to
double.
3. Drop the attribute ?depttname? from the table? emp? .
co?l ?
(C)
Explain different users of database approach
C01

Q.3
, Attempt following queries
C03
8X1
* (A);
Attempt any 4 sq] queries for following.
fb)
,. c)
e)
Employee(e_name, street, city)
Works(e_name, c_name, sal)
Company(c_name, city)
Manages(e_name,manager__name,city) .
F ind names of all employees who works for wipro and earn more than
10000 "
Find company name which is located in same city as that of wipro
(asswne wipro isalocated at multiple location)
Find company name'that has most number of employees ? ? ? "
Find names of employec who cams more than wipro employee
F ind name of employee who liVes in same city as Ramesh.
Find name of employee who earns more than average salary of wipro
employee ' *
Mm End *wa