Any relation that is not part of the logical model, but is made visible to a user as a a)Absolute relation b)Natural relation c)Virtual relation d)Linear relation 7.Which of the following query is correct? a)SELECT ename FROM employee WHERE age>30 and WHERE age <40; b)SELECT ename FROM employee WHERE age>30 and age <40; c)None of these d)SELECT ena
6.Any relation that is not part of the logical model, but is made visible to a user as a
a)Absolute relation
b)Natural relation
c)Virtual relation
d)Linear relation
7.Which of the following query is correct?
a)SELECT ename FROM employee WHERE age>30 and WHERE age <40;
b)SELECT ename FROM employee WHERE age>30 and age <40;
c)None of these
d)SELECT ename FROM employee WHERE age>30 and <40;
8.Produces a relation that contains all the rows of R1, or R2, or both R1 and R2, duplicate tuples being eliminated. R1 and R2 must be union-compatible.
a)R1 left outer join R2
b)R1 X R2
c)R1 U R2
d)R1 - R2
9.Find the EmpIds of employees with name and city whose city is either RYK or LHR but empid must be greater than 5
a)SELECT empid, name,city FROM emp WHERE city = 'RYK' AND city ='LHR' AND empid >5);
b)SELECT empid, name,city FROM emp WHERE city = 'RYK' OR city ='LHR' AND empid >5);
c)SELECT empid, name,city FROM emp WHERE city = 'RYK' OR city ='LHR' OR empid >5);
d)SELECT empid, name,city FROM emp WHERE city = 'RYK' AND city ='LHR' OR empid >5);
10.Which of the following ensures the consistency of the transactions?
a)Transaction management
b)Recovery management
c)concurrency control
d)Application programmer
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
