SQL Operator Set 2

Concatenation operator manipulates

Datetime Literals

Number Literals

Text Literals

Integer Literals

Which of the following are Comparison Operators ?

ANY
SOME

IN
NOT IN

BETWEEN
AND

IS NULL
IS NOT NULL

LIKE
NOT LIKE

ALL OF ABOVE

Which of the following is trure about logical operator ?

NOT :Returns TRUE if the following condition is FALSE. Returns FALSE if it is TRUE. If it is UNKNOWN, it remains UNKNOWN.

AND :Returns TRUE if both component conditions are TRUE. Returns FALSE if either is FALSE. Otherwise returns UNKNOWN.

OR:Returns TRUE if either component condition is TRUE. Returns FALSE if both are FALSE. Otherwise returns UNKNOWN.

All of above

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

UNION

UNION ALL

INTERSECT

MINUS

Which of the following returns distinct rows those are returned by two queries ?

UNION

UNION ALL

MINUS

INTERSECT

How to select ename from Emp table where Comm is Null ?

SELECT ename, deptno
FROM emp
WHERE comm IS NULL

SELECT ename, deptno
FROM emp
WHERE comm NULL

SELECT ename, deptno
FROM emp
WHERE comm == NULL

All the above

IN equals to "ANY" and
NOT IN equals to "ALL"

true

false

Which of the following statement is wrong ?

'Any' means less than maximum

'Any' means more than minimum

'Any' is equivalent to in

Non of these

Which of the following is correct to Select all employees whose second letter contains ‘U’?

select empno, ename from Emp where ename like '_U_%';

select empno, ename from Emp where ename in '_U%';

select empno, ename from Emp where ename is '_U%';

select empno, ename from Emp where ename like '_U%';