TECHNICAL INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 4

INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 4

1. The sql statement

 SELECT LENGTH (' ') FROM DUAL ;  -- ''  is two single quotes

prints

(A)0
(B)a gargabe value
(C)NULL
(D) 1

CLICK HERE TO SEE THE ANSWER

ANSWER IS (C)

2.The sql statement

 SELECT INSTR ( 'abcdecfg' , 'c')  FROM DUAL ;

prints

(A)2
(B)3
(C)5
(D) 6

CLICK HERE TO SEE THE ANSWER

ANSWER IS (B)

3.The sql statement

 SELECT LPAD ('abcd' ,10,'*') FROM DUAL ;

prints

(A)abcd******
(B)*****abcd
(C)***abcd***
(D) *********

CLICK HERE TO SEE THE ANSWER

ANSWER IS (B)

4.The sql statement

SELECT (NVL (NVL (NULL, 3), 4)) FROM DUAL;

 prints

(A)3
(B)4
(C)NULL
(D) NONE OF THESE

CLICK HERE TO SEE THE ANSWER

ANSWER IS (A)

5.The sql statement

SELECT "Hi' FROM DUAL WHERE 1 != NULL;

prints

(A) Hi
(B)FALSE
(C)TRUE
(D) NOTHING

CLICK HERE TO SEE THE ANSWER

ANSWER IS (D)

NEXT SET 5 || PREVIOUS SET 3