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
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
3.The sql statement
SELECT SUBSTR('123456879' , INSTR( 'bacabcabc' , 'b', 4)) FROM DUAL;
prints
(A)2345
(B)6789
(C)56789
(D)89
ANSWER IS (A)