TECHNICAL INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 1

  
INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 1

1. The sql statement 

NOT BETWEEN 10 AND 20

(A)  Displays NULL values

(B) Does not display NULL values

(C) May display NULL  values

(D)  None of these

CLICK HERE TO SEE THE ANSWER

ANSWER IS (B)

2. The sql statement

SELECT SUBSTR('123456789', INSTR('ABCABCABC', 'B' ), 4) FROM DUAL;

prints

(A) 6789

(B) 2345

(C) 1234

(D) 456789

CLICK HERE TO SEE THE ANSWER

ANSWER IS (B)

3.Which of the following group functions ignore NULL values ?

(A)  MAX

(B)COUNT

(C) SUM

(D) COUNT(*)

CLICK HERE TO SEE THE ANSWER

ANSWER IS (A) , (B) AND (C)

4.The SELECT 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)

5.   The sql statement

SELECT  SUBSTR('abcdefghij' , INSTR ('123321234' , '2' ,3 , 2) , 2)

FROM DUAL

prints

(A) gh

(B) 23

(C) bc

(D) ab

CLICK HERE TO SEE THE ANSWER

ANSWER IS (A)

.....NEXT SET 2.....