PGT Computer Science (Level-3), (HTET Exam 2016)

Total Questions: 150

141. .................... command provides a window through which one can see the data of another table.

Correct Answer: C. CREATE VIEW

142. In SQL decimal data type, ................... indicates the maximum number of digits to the right of decimal point.

Correct Answer: D. Scale

143. An application system analyst is concerned about all of the database at the ................... level.

Correct Answer: A. Logical

144. ................. Sorting compares two adjoining values and exchange them if they are not in proper order.

Correct Answer: C. Bubble
Solution:

The bubble sort makes multiple passes through a list. It compares adjacent items and exchanges those that are out of order. Each pass through the list places the next largest value in its proper place. In essence, each item "bubbles" up to the location where it belongs.

145. .................. generation of computers started to use assembly language.

Correct Answer: B. 2nd

146. A 2-D array A[4...7, -1...3] requires 2 bytes of storage space for each element. If the array is stored in rowmajor form having base address 100, then the address of A[6, 2] will be ..................... .

Correct Answer: B. 126

147. ................... is an example of full duplex system.

Correct Answer: D. Telephone
Solution:

Full-duplex System: The communication can take place in both the directions simultaneously between two systems; however, separate conductor wires are required for transmission and reception. The telephone line is an example of a full-duplex system.

148. The explicit conversion of an operand to a specific type is called ..................

Correct Answer: С. Туре casting

149. Which of the following control expressions are valid for an "IF statement"?

Correct Answer: A. Boolean

150. The members of a structure variable can be referenced using ................. operator.

Correct Answer: A. . (dot)