LEARN2PROGRAMS: TECHNICAL INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 2

Thursday, 19 June 2014

INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 2

1. From the following combinations of wildcard characters , choose those that are equivalent.

(A) %

(B) _%

(D) __

ANSWER IS (B) AND (C)

2. The sql statement

SELECT ROUND (45.926 , -1) FROM DUAL ;

(A) is illegal

(B) prints garbage

(D) prints 50

ANSWER IS (D)

3. Which of the following must be enclosed in double qoutes?

(A)Dates

(B)Column Alias

(C)Strings

(D) All of these

ANSWER IS (B)

4. The SELECT statement

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

outputs

(A) true

(B)Hi

(C)FALSE

(D) Nothing

ANSWER IS (D)

5. In sql SQL , 10/NULL will evalute to

(A) FALSE

(B)-1

(D) 10

ANSWER IS (C)

NEXT SET 3 || PREVIOUS SET 1

LEARN2PROGRAMS