TECHNICAL INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 3

INTERVIEW QUESTIONS ON SQL / PLSQL-- SET3

1. Almost all the DATE functions return a value of data type DATE , except

(A)MONTHS_BETWEEN

(B)ROUND

(C)NEXT_DAY

(D) TRUNC

CLICK HERE TO SEE THE ANSWER

ANSWER IS (A)

2.The SELECT statement 

SELECT LOWER ('AbCd') , UPPER('AbCd'), INITCAP ('AbCd EFgh') FROM DUAL;

will print

(A)abcd ABCD Abcd Efgh

(B)abcd ABCD ABCD EFGH

(C)abcd ABCD abcd efgh

(D)abcd ABCD aBCD eFGH

CLICK HERE TO SEE THE ANSWER

ANSWER IS (A)

3.The sql statement

SELECT SUBSTR('123456879' , INSTR( 'bacabcabc' , 'b', 4)) FROM DUAL;

prints

(A)2345

(B)6789

(C)56789

(D)89

CLICK HERE TO SEE THE ANSWER

ANSWER IS (C)

4. The sql statement 

SELECT TRUNC(45.926 , -1)  FROM DUAL;

(A)is illegal

(B)5

(C)prints 45.9

(D)prints 40

CLICK HERE TO SEE THE ANSWER

ANSWER IS  (D)

5.The sql statement 

SELECT 'Hi' FROM DUAL WHERE NULL =NULL ;

prints

(A) Hi

(B)FALSE

(C)TRUE

(D)nothing

CLICK HERE TO SEE THE ANSWER

ANSWER IS  (D)

NEXT SET 4 || PREVIOUS SET2