TECHNICAL INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 2

 INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 2

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

(A) %

(B) _%

(C) %_

(D) __

CLICK HERE TO SEE THE ANSWER

ANSWER IS (B) AND (C)

2. The sql statement 

SELECT  ROUND (45.926 , -1)  FROM DUAL ;

(A) is illegal

(B) prints garbage 

(C) prints 045.926

(D) prints 50

CLICK HERE TO SEE THE ANSWER

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

CLICK HERE TO SEE THE ANSWER

ANSWER IS (B)

TECHNICAL INTERVIEW AND PRACTICE QUESTIONS ON C++ -- SET 2

 TECHNICAL INTERVIEW AND PRACTICE QUESTIONS ON C++

 -- SET 2 --

 1. The following C++ code results in

#include "iostream.h"
void main(void)
{
cout<<(int i = 5)<<(int j=6);
}

(a)  compilation error                          (b) run time error

(c) link time error                               (d)  none of the above

CLICK HERE TO SEE THE ANSWER

ANSWER IS A

2.  Reusability is a desirable feature of a language as it

(a)  decrease the testing time                   (b) lowers the maintence cost

(c)  reduces the compilation time             (d) reduces the execution time

CLICK HERE TO SEE THE ANSWER

ANSWER IS A and B

3. Choose the correct statements regarding inline functions.

(a)  It speeds up execution                      (b)  It slows down execution

(c)  It increases the code size                  (d)  It decreases the code size

CLICK HERE TO SEE THE ANSWER

ANSWER IS A and C