PSC Computer Operator – KIRTADS Model Questions and Answers

51. The communication device that uses spanning tree algorithm to avoid loops:
(A) Router (B) Gateway
(C) Bridge (D) Switch
Answer: C

52. Delaying an outgoing control frame in order to hook onto the next outgoing data frame is called:
(A) Packet Sniffing (B) Compounding
(C) Optimal Routing (D) Piggy Backing
Answer: D

53. Dijkstra’s algorithm facilitates:
(A) Multipathing (B) Shortest Path Routing
(C) Isolated Routing (D) Centralised Routing
Answer: B

54. The OSI Layer in which the auto negation resides is:
(A) Physical (B) Network
(C) Transport (D) Data Link
Answer: A

55. The transmission media that uses BNC connector is:
(A) Coaxial Cable (B) UTP
(C) STP (D) Optical Fiber
Answer: A

56. The mode of communication used in a serial communication channel is:
(A) Simplex (B) Half duplex
(C) Full duplex (D) Both (B) and (C)
Answer: C

57. The communication standard for a wireless network is specified by
(A) 802.11 (B) 802.21
(C) 802.8 (D) 802.12
Answer: A

58. The FDDI network is an example of:
(A) Bus (B) Star
(C) Ring (D) Mesh
Answer: B

59. A standard protocol for packet switching is:
(A) POTS (B) SMTP
(C) PSTN (D) X.25
Answer: D

60. The number of bits in a MAC Address is:
(A) 32 (B) 48
(C) 64 (D) 128
Answer: B

61. Which of the following is not a relational operator?
(A) Difference (B) Addition
(C) Division (D) Selection
Answer: B

62. In DBMS, the front end application performs:
(A) Storage function (B) Access control
(C) Processing function (D) All of the above
Answer: C

63. In a table, the relationship among a set of values are represented by:
(A) Tuple (B) Attribute
(C) Entity (D) Key
Answer: A

64. The Schema that provides a standard way of organizing information into accessible parts:
(A) Logical (B) Physical
(C) External (D) Storage level
Answer: A

65. The physical location of a database record is determined by a key transformation in:
(A) Index (B) Random
(C) Hash (D) Pointer
Answer: C

66. Which of the following is not a set operator in SQL?
(A) UNION (B) UNION ALL
(C) MINUS (D) LIKE
Answer: D

67. Which one of the following is a procedural language?
(A) Domain relational calculus (B) System-R
(C) Query language (D) Relational language
Answer: D

68. A buffer that has been changed in database buffer memory, but not yet written to disk is:
(A) Swap space (B) Latch
(C) Redo Log (D) Dirty Block
Answer: D

69. The timestamp ordering that makes no distinction between the Read and Write access so that only a single value is required for each granule is:
(A) Partial timestamp ordering
(B) Total timestamp ordering
(C) Multi version timestamp ordering
(D) Optimal timestamp ordering
Answer: B

70. The constraint specifying that account number must be in between 50000 and 80000 is a:
(A) Integrity constraint (B) Referential constraint
(C) Default constraint (D) Key constraint
Answer: A

71. In a Java program, the length in pixel of a string can be obtained using the method:
(A) Stringwidth (B) Strlength
(C) Length (D) Strwidth
Answer: A

72. Select the correct statement from the following :
(A) Char p=(char*)malloc(100);
(B) char *p=(char*)malloc(100)l
(C) Char p=(malloc(100));
(D) char *p=(char*)malloc(100);
Answer: D

73. The statement that is least preferred in C programs in general is:
(A) Recursion (B) Nesting of different type of loops
(C) Double pointer (D) Unconditional Jump to a label
Answer: D

74. What will be the output of following C++ program?

#include<iostream.h>
Void main()
{
char *cp= “computer”;
cp+=2
(*cp)++;
cout<<cp;
}

(A) puter (B) mputer
(C) nputer (D) quter
Answer: C

75. What will be the output of following C++ program?

#include<iostream.h>
void main()
(
int x=10,y=5,z;
z=++x+(++y)++;
cout<<z;
}

(A) 15 (B) 16
(C) 17 (D) 18
Answer: C