TECHNICAL INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 5

 INTERVIEW QUESTIONS ON SQL / PLSQL-- SET 5

1. The sql statement 

 SELECT  LAPD( 'abcd' ,10, 'wert')  FROM DUAL;

prints

(A) wertweabcd

(B)abcdwertwer

(C)wertwertab

(D)abwertwert

CLICK HERE TO SEE THE ANSWER

ANSWER IS (A)

2.The sql statement 

 SELECT ROUND (45.926, -2) FROM DUAL;

(A) is illegal

(B)prints garbage

(C)prints 45.92

(D) prints 0

CLICK HERE TO SEE THE ANSWER

ANSWER IS (D)

3.The sql statement 

 SELECT NVL(NVL(NULL, NVL(NULL, 3)) , 4)  FROM DUAL;

prints

(A) 3

(B)4

(C)NULL

(D) IS ILLEAGAL

TECHNICAL INTERVIEW AND PRACTICE QUESTIONS ON JAVA - SET 5

INTERVIEW AND PRACTICE QUESTIONS ON JAVA - SET 5

1. Automatic conversion from priitive type to an object of the corresponding wrapper class is called

(A)  coercing

(B)  casting

(C) boxing

(D) widening 

CLICK HERE TO SEE THE ANSWER

ANSWER IS (C)

2.  The fact that any program can print using system.out.print , implies that 

(A)  system is defined in the package java.lang

 (B) system is a class name

(C) out is an object 

(D) print is a method 

CLICK HERE TO SEE THE ANSWER

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

3. Which of the following are valid identifers?

(A) $ABC 

(B) _____(5 consecutive underscores)

(C) main

(D) protected

CLICK HERE TO SEE THE ANSWER

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

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

SET 5  TECHNICAL INTERVIEW QUESTIONS ON C++

1.  Select the correct Statements

(a)  A destructor is not inherited                         (b)  A constructor cannot be called explicitly

(c) A destructor can be called explicitly             (d) A contructor is not  inherited

CLICK HERE TO SEE THE ANSWER

ANSWER IS (a) , (b) and (d)

2.  The compiler identifies a virtual function to be pure

(a)  by the presence of keyword  PURE             (b)  by its location in the program

(c) if it is equated to 0                                       (d) none of the above

CLICK HERE TO SEE THE ANSWER

ANSWER IS  (C)

3.  A class having no name


(a)  is not allowed

(b) cannot have a contructor

(c)  cannot have a destructor

(d) cannot be passed as argument

CLICK HERE TO SEE THE ANSWER

ANSWER IS (b) , (c) and (d)