SQL Operator Set 3

A wildcard character '%' indicates

matches any string of more than one characters

matches any string of zero characters

matches any string of zero or more characters

Non of these

How to select record from Emp where 'ename' ends with 'i' ?

SELECT * FROM emp WHERE ename LIKE'%i'

SELECT * FROM emp WHERE ename LIKE'%I'

SELECT * FROM emp WHERE ename LIKE'%i%'

SELECT * FROM emp WHERE ename LIKE'_i'

Which of the following returns all rows from queries; including duplicate rows ?

UNION

UNION ALL

MINUS

INTERSECT

Which of the following is a set operator ?

NOT LIKE

MINUS

MOD

Which of the following statements are correct ?

'All' means less than the maximum

'All' means less than the minimum

'All' is equivalent to some

All of above

Which of the following is correct to find the employees from EMP table who are not working in department 40

select * from Emp where deptno < 10;

select * from Emp where deptno <= 10;

select * from Emp where deptno <> 10;

select * from Emp where deptno >=10;

Which of the following is correct to Select all employees from EMP whose salary is between 2000 and 5000 ?

select ename, salfrom Emp where sal between 2000 ,5000;

select ename, salfrom Emp where sal between 2000 and 5000;

select ename, salfrom Emp where sal in between 2000 and 5000;

select ename, salfrom Emp where sal in between 2000,5000;

The NVL function will substitute 0 with null.

true

false

Which is not a logical operator ?

EXISTS

BETWEEN

ANY

IS NULL

Non of above