11.Which of the following query finds the names of the employees who have taught at least one course? a)SELECT DISTINCT e.ename FROM employee e, course c WHERE e.eid = c.cid; b)SELECT e.ename FROM employee, course WHERE e.eid = c.cid; c)None of these d)SELECT e.ename FROM employee e, course c WHERE e.eid = c.cid; 12.If A-> B, C,D,E and D -> E are functional dependencies of the relation R(A,B,C,D,E) Then identify the best normal form of the given relation R. a)2NF b)BCNF c)3NF d)1NF 13.The attributes of relationship completes in employee completes course should be a)empid, cno, cname, grade b)empid, cno, grade c)empid, ename, dept, phone no d)cno, cname, grade
11.Which of the following query finds the names of the employees who have taught at least one course?
a)SELECT DISTINCT e.ename FROM employee e, course c WHERE e.eid = c.cid;
b)SELECT e.ename FROM employee, course WHERE e.eid = c.cid;
c)None of these
d)SELECT e.ename FROM employee e, course c WHERE e.eid = c.cid;
12.If A-> B, C,D,E and D -> E are functional dependencies of the relation R(A,B,C,D,E)
Then identify the best normal form of the given relation R.
a)2NF
b)BCNF
c)3NF
d)1NF
13.The attributes of relationship completes in employee completes course should be
a)empid, cno, cname, grade
b)empid, cno, grade
c)empid, ename, dept, phone no
d)cno, cname, grade
14.What is the meaning of LIKE 'a%a%'
a)Feature ends with two a's
b)Feature begins with two a's
c)Feature has two a's in it, at any position
d)Feature begins with a and has at least one a's in it at any position
15.If in JOIN operation, conditions of JOIN operation are not satisfied then results of operation is
a)zero tuples and empty relation
b)one tuple from one relation
c)one tuple from two relation
d)two tuples from empty relations
Step by step
Solved in 2 steps
