TECHNICAL INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 5

 INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 5

1. The sql statement 

 SELECT  LAPD( 'abcd' ,10, 'wert')  FROM DUAL;

prints

(A) wertweabcd

(B)abcdwertwer

(C)wertwertab

(D)abwertwert

CLICK HERE TO SEE THE ANSWER

ANSWER IS (A)

2.The sql statement 

 SELECT ROUND (45.926, -2) FROM DUAL;

(A) is illegal

(B)prints garbage

(C)prints 45.92

(D) prints 0

CLICK HERE TO SEE THE ANSWER

ANSWER IS (D)

3.The sql statement 

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

prints

(A) 3

(B)4

(C)NULL

(D) IS ILLEAGAL

CLICK HERE TO SEE THE ANSWER

ANSWER IS (A)

4.The sql statement 

 SELECT DECODE(2, 2, DECODE(3, 7, 2, 4, 5, 6)) FROM  DUAL;

prints

(A)2

(B)5

(C)6

(D)7

CLICK HERE TO SEE THE ANSWER

ANSWER IS (C)

5.The sql statement 

SELECT "Hi' FROM DUAL WHERE NULL IN (NULL);

outputs

(A)TRUE

(B)FALSE

(C)'Hi'

(D)NOTHING

CLICK HERE TO SEE THE ANSWER

ANSWER IS (D)

NEXT SET 6|| PREVIOUS SET 4