HTET PGT COMPUTER SCIENCE (CS) OLD QUESTION PAPER WITH ANSWER SOLUTION MCQ


91. Socket address is :






Answer : B) Combination of IP address and port address

92. Choose valid set of output devices :






Answer : C) Plotter, VDU, Headphone

93. Which of the following constructor related concept is non-relevant in C++ ?






Answer : D) virtual constructor

94. Boolean expression ~ (A * B) * (~A+ B) * (~B + B) is equal to which of the following ?






Answer : A) ~A

95. Terms NTFS and FAT 32 are closely related to which action on computer ?






Answer : D) Formatting

96. Datagram networks are also referred to as .......... networks.






Answer : C) Connectionless

97. In the context of computers and internet, choose the odd one out from the following :






Answer : D) Comodo

98. VGA stands for :






Answer : A) Video Graphics Array

99. SQL command used to add a new column in an existing table is :






Answer : A) ALTER

100. ........ are used to identify a user who returns to a website.






Answer : D) Cookies

101. As per Nyquist theorem, to reproduce the original analog signal one necessary condition is that the sampling rate be at least .......... the






Answer : A) twice

102. 2^30 bytes and 2^50 bytes are respectively equal to ........ and .......






Answer : B) 1 Gigabyte, 1 Petabyte

103. In the context of internet, .......... is related with the rules of framing messages that will not hurt other users of internet.






Answer : B) NETIQUETTE

104. LOC oriented software estimation model E = 3.2 * (KLOC)^1.05 is called :






Answer : C) Boehm simple model

105. In windows 8.1 which of the following options in control panel is related to adjustment of display brightness, volume and power options ?






Answer : A) Windows Mobility Center

106. In context of deadlock prevention in DBMS, wait-die and wound-wait schemes are techniques.






Answer : D) non-preemptive and preemptive respectively

107. In C++, which of the following is not a derived container under STL ?






Answer : B) deque

108. Sum of degrees of all nodes for a graph G(V, E) can be given by ......






Answer : B) 2 x |E|

109. Under personalization in windows we can create .......... to change desktop background, color, sound and screen saver all at once.






Answer : B) themes

110. In MS-Excel ..... option can be used to keep the desired rows and columns visible while the rest of the sheet scrolls.






Answer : C) Freeze panes

111. Calculate the required bit rate of a channel if we need to download a text document at the rate of 100 pages per minute. Assume that a page has 24 lines with 80 characters in each line and one character is represented using 8 bits :






Answer : *

112. IEEE 802.11 standard belongs to :






Answer : A) Wireless LAN

113. In HTML5 the ............. element is used to include images, graphs and compound objects that contain text and images, in webpage.






Answer : A) < figure >

114. Consider Column-I and Column-II :

Column-I Column-II
i. 3D Studio     a. Search Engine
ii. Ubuntu     b. Anti virus
iii. Duck Duck Go     c. Animation
iv. Maxthon     d. Operating System
v. Vipre Rescue     e. Web Browser
Match the Column-I and Column-II is :






Answer : B) i-c, ii-d, iii-a, iv-e, v-b

115. In C++, an overloaded unary operator defined as a member function requires how many variables to be passed as function argument ?






Answer : A) Zero

116. How many times ‘save trees’ will be displayed by C++ loop ?

do
{
  cout < < "save trees";
} while(0);






Answer : A) One

117. In HTML version-5, the purpose of this element is to encapsulate group of links :






Answer : C) < nav >

118. In context of MS-Word, with a ......... indent, the second and all the following lines of a paragraph are indented more than the first line of the paragraph.






Answer : D) hanging

119. In context of databases consider set operations on relation R and S, and select a true statement :






Answer : C) (R – S) ∩ (S – R) = Φ

120. Which of the following is not a valid expression of Boolean algebra ?






Answer : B) x * ~ y + ~ x * y + ~ x * ~ y = 1

121. Term ‘bath tub curve’ is related to .....






Answer : D) Hardware failure rate

122. In context of 2-phase locking protocol in DBMS, a transaction issues lock requests in .......... phase and unlock requests in .......... phase.






Answer : A) Growing, Shrinking

123. In directed graph G(V, E) where V = {P, Q, R, S, T} and E = {PQ, RS, TP, PS, QR, PT, ST, QP, RQ, TS}, the vertex with maximum in- degree is .......... and vertex with maximum out-degree is .........






Answer : D) S, P

124. Consider Column-I and Column-II in context of C++ :

Column-I Column-II
i. Private         a. Data type modifier
ii. Sizeof         b. Visibility specifier
iii. Static         c. Operator
iv. Long         d. Storage class
Match the Column-I and Column-II is :






Answer : D) i-b, ii-c, iii-d, iv-a

125. Calculate number of page faults for reference string 3, 2, 4, 1, 3, 5, 2, 1, 7, 3, 0 considering four frames and eight pages of equal size and LRU page replacement technique :






Answer : C) 5

126. In context of semaphores choose the option with valid codes for wait() and signal() functions :






Answer : B) Wait (s) { while (s) < = 0; s – – } and signal (s) { s + +; }

127. 1000 of 8421 binary coding system is equal to 1011 in .......... binary coding.






Answer : B) Excess-3

128. In MS-PowerPoint-2007, size of a slide can be set to A4 size using which of the following options ?






Answer : B) Design – page setup

129. Choose true statements about virtual functions in C++ : I : The virtual functions must be member of some class. II : They cannot be static members. III : A virtual function can be a friend of another class.






Answer : D) I, II and III

130. In OSI model match the following :

Column-I Column-II
i. Physical layer         a. Dialog control & synchronization
ii. Data link layer         b. Synchronization of bits
iii. Session layer         c. Translation & compression
iv. Presentation layer         d. Error control & framing
Match the Column-I and Column-II is :






Answer : A) i-b, ii-d, iii-a, iv-c

131. In MS-PowerPoint function key F7 is used to .........






Answer : C) run spelling check

132. This element is used to change the current directionality of the text, in HTML :






Answer : D) < bdo >

133. Consider Column-I and Column-II in context of tools to support UML diagram for analysis modeling :

Column-I Column-II
i. Power Designer         a. IBM
ii. Rational Rose         b. Microsoft
iii. Visio         c. Sybase
iv. Argo UML         d. Open source
Match the Column-I and Column-II is :






Answer : B) i-c, ii-a, iii-b, iv-d

134. Choose the SQL commands to perform following operations on a relation R :

I : Retain Relation R in database, but delete all tuples in R.
II. Delete all information about R in Database.






Answer : B) I : Delete from R; II : Drop table R

135. (929.19)10 = ?






Answer : A) (1641.141)8

136. Which of the following output is not expected from MS-excel function = RAND() ?






Answer : B) 1

137. If the following functional dependencies holds on a selection R : A → B, A → C, BC → D, C → F, B → E, then which of the following dependency does not hold on R ?






Answer : D) BD → EF

138. EBCDIC code 1111 1001 represents the character .........






Answer : D) 9

139. Which of the following recurrence relation is related to worst case time complexity of quick sort ?






Answer : C) T(n) = T(n–1) + Cn

140. In MS-Office Word, .......... option is used to navigate through structural view of document and .......... option is used to navigate long document through small pictures of each page.






Answer : D) Document map, thumbnails

141. In context of C++, which of the following is a valid statement ?






Answer : C) Keywords private, protected and public may appear in any order and any number of times in a class.

142. Which of the following pairs represents types of charts in MS- PowerPoint ?






Answer : A) Area, Surface

143. Which of the following is not a web- browser ?






Answer : C) MINIX

144. The ........... of weak entity set distinguishes among all those entities in the weak entity set that depends upon one particular strong entity.






Answer : B) Discriminator

145. In MS-excel if ........ function key is pressed after entering a formula into a cell in place of Enter key, the result of formula is placed as value in the cell and the formula is removed from that cell.






Answer : D) F9

146. The Boolean expression F = (x.y’ + x’.y + x’.y’) is equivalent to :






Answer : B) x’ + y’

147. .......... topology requires highest number of ports and largest amount of cabling in computer networks.






Answer : C) Mesh

148. In …………........ page replacement algorithm, page that will not be used for longest period of time is replaced whenever a page fault occurs.






Answer : B) Optimal

149. In MS-Office Word short cut key used to change case of selected text is :






Answer : D) Shift + F3

150. In context of software testing match of Column-I and Column-II is :

Column-I Column-II
i. Integration Testing   a. Alpha Testing
ii. Unit Testing   b. Usability Testing
iii. Acceptance Testing   c. Data Flow Testing
iv. System Testing   d. Black Box Testing
Match the Column-I and Column-II is :






Answer : C) i-c, ii-d, iii-a, iv-b