1.Find the marks in increasing order of all students a) SELECT reg#, marks FROM student ORDER BY marks; b) SELECT reg# FROM student ORDER BY marks; c) SELECT reg#, marks FROM student; d) SELECT reg#, marks FROM student ORDER BY reg#; 2.Find the EmpIds of employees with name and city whose city is neither RYK nor LHR a )SELECT empid, name,city FROM emp WHERE city NOT IN ('RYK', 'LHR'); b) SELECT empid, name,city FROM emp WHERE city NOT BETWEEN ('RYK', 'LHR'); c) SELECT empid, name,city FROM emp WHERE city BETWEEN ('RYK', 'LHR'); d) SELECT empid, name,city FROM emp WHERE city IN ('RYK', 'LHR'); 3.Keeps specified tuples and discards the others: a) Join b) None c) Select d) Project 4.If A,B-> C,D,E and B -> 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) BCN c)3NF d)1NF 5.If a3-> a1,a2,a4 is a functional dependency of the relation A(a1,a2,a3,a4) Then identify the best highest normal form of the given relation A. a) 2NF b)1NF c)3NF d)BCNF
1.Find the marks in increasing order of all students
a) SELECT reg#, marks FROM student ORDER BY marks;
b) SELECT reg# FROM student ORDER BY marks;
c) SELECT reg#, marks FROM student;
d) SELECT reg#, marks FROM student ORDER BY reg#;
2.Find the EmpIds of employees with name and city whose city is neither RYK nor LHR
a )SELECT empid, name,city FROM emp WHERE city NOT IN ('RYK', 'LHR');
b) SELECT empid, name,city FROM emp WHERE city NOT BETWEEN ('RYK', 'LHR');
c) SELECT empid, name,city FROM emp WHERE city BETWEEN ('RYK', 'LHR');
d) SELECT empid, name,city FROM emp WHERE city IN ('RYK', 'LHR');
3.Keeps specified tuples and discards the others:
a) Join
b) None
c) Select
d) Project
4.If A,B-> C,D,E and B -> 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) BCN
c)3NF
d)1NF
5.If a3-> a1,a2,a4 is a functional dependency of the relation A(a1,a2,a3,a4)
Then identify the best highest normal form of the given relation A.
a) 2NF
b)1NF
c)3NF
d)BCNF
Step by step
Solved in 2 steps
