Web Tech./DS/OS/Java/Oracle/C++ Test Set 3

1)   C++: Catch handler can have multiple parameters.

a. True
b. False


Answer  Explanation 

ANSWER: False

Explanation:
A catch handler should contain only one parameter of any type. Multiple parameters are not allowed inside catch handler.


2)   C++: It is not possible to combine two or more file opening mode in open () method.

a. True
b. False


Answer  Explanation 

ANSWER: False

Explanation:
We can combine two or more than two file opening modes by ORing them.


3)   C++: RunTime Polymorphism is achieved by ______

a. Friend function
b. Virtual function
c. Operator overloading
d. Function overloading
Answer  Explanation 

ANSWER: Virtual function

Explanation:
Virtual functions helps to call member functions of different class by a same function call depending on the context.


4)   C++: Overloading the function operator

a. Requires a class with an overloaded operator.
b. Requires a class with an overloaded [ ] operator.
c. Allows you to create objects that act syntactically like functions.
d. Usually make use of a constructor that takes arguments.
Answer  Explanation 

ANSWER: Requires a class with an overloaded operator.

Explanation:
An overloaded declaration is declared with the same name as the previously declared declaration in the same scope except that both the declarations have different arguments and different definition.


5)   C++: Scope resolution operator is used______

a. To resolve the scope of global variables only
b. To resolve the scope of functions of the classes only
c. To resolve scope of global variables as well as functions of the classes
d. None of these
Answer  Explanation 

ANSWER: To resolve scope of global variables as well as functions of the classes

Explanation:
The Scope resolution operator(::) is used to define a function outside a class or when we want to use a global variable but which also has a local variable with same name.


6)   C++: The purpose of explicit keyword is to tell the compiler that a certain constructor may not be used to implicitly cast an expression to its class type.

a. True
b. False


Answer  Explanation 

ANSWER: True

Explanation:
The explicit keyword is used so that the constructor does not communicate implicitly.


7)   PL/SQL: Varrays are a good choice when -

a. The number of elements is known in advance.
b. The elements are usually all accessed in sequence.
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: Both A & B

Explanation:
A varray can store a fixed sequential collection of elements of the same type. It is used to store ordered collection of data.


8)   PL/SQL: Which of the following cannot be used with associative arrays?

a. EXTEND
b. TRIM
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: Both A & B

Explanation:
The associative arrays are sets of key value pairs where each key is unique and used to locate a corresponding value in the array.


9)   PL/SQL: Which datatypes can be used with a RECORD Type?

a. NUMBER,VRCHAR2
b. %TYPE,OR %ROWTYPE
c. REF,CURSOR
d. BOTH A & B
e. BOTH B & C
Answer  Explanation 

ANSWER: BOTH A & B

Explanation:
A record is a data structure that can hold data items of different kinds. It consists of different fields similar to a row of a database table.


10)   PL/SQL: Is it possible to define a NOT NULL field in a record?

a. Yes
b. No


Answer  Explanation 

ANSWER: Yes

Explanation:
The not null field helps us return all the not null records. It is like giving a condition to the block or the expression.


11)   PL/SQL: SIGNTYPE lets you restrict an integer variable to the values -1, 0, and 1, which is useful in programming tri-state logic.

a. True
b. False


Answer  Explanation 

ANSWER: True

Explanation:
Signtype is a subtype of binary integer. It requires less storage.


12)   PL/SQL: Dynamic SQL enables you to build SQL statements dynamically at runtime.

a. True
b. False


Answer  Explanation 

ANSWER: True

Explanation:
Dynamic SQL helps to write programs that refer SQL statements whose full text is not known until the runtime.


13)   PL/SQL: The DBMS_SQL package should be used in which of the following situations?

a. 13. There is an unknown number of input or output variables, such as the number of column values returned by a query, that are used in a dynamic SQL statement.
b. The dynamic code is too large to fit inside a 32K bytes VARCHAR2 variable.
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: Both A & B

Explanation:
The DBMS_SQL package provides an interface to use dynamic SQL to parse any data manipulation language (DML) or data definition language (DDL) statement using PL/SQL


14)   C programming:

main()
{
int x;
if ( x > 4) printf( “Brinda”);
else if ( x > 10) printf( “Karthik”);
else if ( x > 21 ) printf(“ Pradeep”);
else printf( “Sandeep”);
}

What will be the value of x so that “Karthik” will be printed?


a. From 10 to 21
b. From 11 to 21
c. Grater then 10
d. None
Answer  Explanation 

ANSWER: None

Explanation:
The logic for this program would be if x> 4 Brinda will be printed if x>10 Brinda and Karthik will be printed and x> 21 Brinda,Karthik and Pradeep will be printed. Hence, None would be the answer for the above program.


15)   C programming: To use the function tolower(), which of the following header file should be used

a. string.h
b. conio.h
c. ctype.h
d. None of the mentioned
Answer  Explanation 

ANSWER: ctype.h

Explanation:
The ctype.h header file is used for character handling functions. It is further divided into several header files. The tolower() is a character case mapping function converts to lowercase.


16)   C programming: The compiler will give an error if we attempt to get the address of a variable with _________ storage class.

a. register keyword
b. extern keyword
c. static keyword
d. auto keyword
Answer  Explanation 

ANSWER: register keyword

Explanation:
Registers are faster to access, so the variables which are most frequently used in a C program can be put in registers using register keyword. The keyword register hints to compiler that a given variable can be put in a register. It’s compiler’s choice to put it in a register or not. Compilers themselves do optimizations and put the variables in register.


17)   C Programming: Queue can be used to implement

a. Radix sort
b. Quick sort
c. Recursion
d. Depth first search
Answer  Explanation 

ANSWER: Radix sort

Explanation:
Radix sort is a non comparative integer sorting algorithm which sorts the data with the integer keys by the individual digits which share the same position and value.


18)   C programming: Which of the following is TRUE about argv?

a. It is an array of character pointers
b. It is a pointer to an array of character pointers
c. It is an array of strings
d. None of above
Answer  Explanation 

ANSWER: It is an array of character pointers

Explanation:
argv stands for 'argument vector'. Vector is a one dimensional array and argv is a one dimensional array of strings.


19)   C programming: Which is not a storage class?

a. Auto
b. Struct
c. Typedef
d. Static
Answer  Explanation 

ANSWER: Struct

Explanation:
Structure allows to combine data items of different kinds.


20)   Networking: What flavor of Network Address Translation can be used to have one IP address allow many users to connect to the global Internet?

a. 32 bits
b. 128 bytes
c. 64 bits
d. 128 bits
Answer  Explanation 

ANSWER: 128 bytes

Explanation:
Network Address Translation(NAT) is a methodology of remapping one IP address into another by modifying the network address in IP datagram packets.


21)   Networking: Which of the following is the valid host range for the subnet on which the IP address 192.168.168.188 255.255.255.192 resides?

a. 21. 192.168.168.129-190
b. 21. 192.168.168.129-191
c. 21. 192.168.168.128-190
d. 21. 192.168.168.128-192
Answer  Explanation 

ANSWER: 21. 192.168.168.129-190

Explanation:
Subnet is a logical, visible subdivision of an IP network. The computers which belong to a subnet are addressed with a common, identical and most-significant bit-group in their IP address.


22)   Networking: ISDN is an example of ______ network

a. Circuit switched
b. Packet switched


Answer  Explanation 

ANSWER: Circuit switched

Explanation:
Circuit switching helps in implementing a telecommunications network in which two nodes establish a dedicated communication channel.


23)   Networking: Contention is ________

a. One or more conductors that serve as a common connection for a related group of devices
b. a continuous frequency capable of being modulated or impressed with a second signal
c. the condition when two or more stations attempt to use the same channel at the same time
d. a collection of interconnected functional units that provides a data communications service among stations attached to the network
Answer  Explanation 

ANSWER: the condition when two or more stations attempt to use the same channel at the same time

Explanation:
Contention is media access method which is used to share a broadcast medium. In this any computer can transmit data any time (first cum first serve basis)


24)   Networking: Which of the following is an advantage to using fiber optics data transmission?

a. Resistance to data theft
b. Fast data transmission rate
c. Low noise level
d. Few transmission errors
e. All of the above
Answer  Explanation 

ANSWER: All of the above

Explanation:
A fiber optic cable has plastic or metal threads for transmitting data. It is capable of transmitting messages modulated on to light waves.


25)   Networking: Which of the following summation operations is performed on the bits to check an error-detecting code?

a. Codec
b. Coder-decoder
c. Checksum
d. Attenuation
Answer  Explanation 

ANSWER: Checksum

Explanation:
a count of the number of bits in a transmission unit that is included with the unit so that the receiver can check and see whether the same number of bits arrived. If the counts match, it's assumed that the complete transmission was received.