SQL Operator Set 1

Which of the following is not arithmetic operator ?

Null is a blank space .

true

false

Select * from emp where job='CLERK' or job='MGR' ; This query will return

All the record where job is 'Cleck'

All the record where job is 'Mgr'

All of the record except job is 'Cleck' or 'Mgr'

All records where job is 'Cleck' or 'Mgr'

Which of the following is not a set operator ?

UNION

INTERSECT

MINUS

Non of the above

How to select record from Emp where 'Emp_Name' start with 'R' ?

SELECT * FROM emp WHERE ename LIKE'R_'

SELECT * FROM emp WHERE ename LIKE'R%'

SELECT * FROM emp WHERE ename not LIKE'R%'

SELECT * FROM emp WHERE ename LIKE'R_%'

SELECT * FROM emp WHERE ename NOT LIKE 'A%'

This query will fetch which of following record ?

All records where ename does start with character 'A'

All records except where ename does start with character 'A'

All records

All of above

Which of the following are not set operators ?

PLUS

MINUS

UNION ALL

Which of the following is wrong ?

Any:Compare to value to every value returned by sub-query

All:Compare to value to each value returned by sub-query

Some: Returned same value as any

None of these

Which of the following is correct to Select all employees from EMP where 'job' contains ‘ADM_’?

select * from Emp where job like 'ADM\_%' Escape '\';

select * from Emp where job like 'ADM\_%''\';

select * from Emp where job like 'ADM\_''%\';

Non of these

Which of the following is correct to selects all Employees with a Employees NOT starting with "A", "S", or "F"?

SELECT * FROM Emp WHERE Emp_Add LIKE '[%ASF]%';

SELECT * FROM Emp WHERE Emp_Add LIKE '[!ASF]%';

SELECT * FROM Emp WHERE Emp_Add Not LIKE '[!ASF]%';

SELECT * FROM Emp WHERE Emp_Add LIKE '[!ASF_]%';