HPSSC Computer Operator Exam - 2020 (Answer Key) | TheExamPillar
HPSSC Computer Operator Answer Key 2020

HPSSC Computer Operator Exam – 10 October 2020 (Official Answer Key)

61. Which of the following arithmetic operators in ‘C’ requires a valid value as its operand ?
(A) *
(B) +
(C) ++
(D) %

Show Answer/Hide

Answer – (C)

62. What is the correct symbol for address operator in ‘C’ ?
(A) *
(B) #
(C) ^
(D) &

Show Answer/Hide

Answer – (D)

63. Which of the following is the correct symbol for logical OR operator in ‘C’?
(A) &&
(B) ++
(C) ||
(D) >>

Show Answer/Hide

Answer – (C)

64. Which of the following is the correct.symbol for bitwise XOR operator in ‘C’ ?
(A) ~
(B) <
(C) |
(D) ^

Show Answer/Hide

Answer – (D)

65. Which of the following is a formatted input function in ‘C’?
(A) getch ()
(B) scanf ()
(C) printf ()
(D) getchar ()

Show Answer/Hide

Answer – (B)

66. Which of the following standard header files in ‘C’ defines the function fscanf()?
(A) stdlib.h
(B) stdio.h
(C) limits.h
(D) studio.h

Show Answer/Hide

Answer – (B)

67. Which of the following, types of expressions is not allowed as Switch Expression in switch…case statement in ‘C’ ?
(A) char
(B) float
(C) enum
(D) int

Show Answer/Hide

Answer – (B)

68. Which of the following statements is not true about functions in ‘C’ programming ?
(A) A function can either return nothing or a single value only.
(B) ‘C’ supports recursive functions.
(C) A function can accept zero or more arguments.
(D) A function can be defined inside another function.

Show Answer/Hide

Answer – (D)

69. What will be the output produced by the following statement in a ‘C’ program ?
printf(“%x”, 64);
(A) 40
(B) 64
(C) 80
(D) x

Show Answer/Hide

Answer – (A)

70. What is the full form of SQL ?
(A) Standard Query Learning
(B) Structured Query Language
(C) Simple Query Language
(D) Simple Queueing Language

Show Answer/Hide

Answer – (B)

71. How many layers are there in ANSI/SPARC model of database architectus
(A) 5
(B) 3
(C) 4
(D) 6

Show Answer/Hide

Answer – (B)

72. Which of the following shapes is used to represent a relationship in ER diagram of a database ?
HPSSC Computer Operator Answer Key 2020

Show Answer/Hide

Answer – (A)

73. A ______ key consists of one or more columns of a database table used to uniquely identify the records of that table.
(A) secondary
(B) foreign
(C) super
(D) primary

Show Answer/Hide

Answer – (D)

74. The Cartesian product of two database tables having two columns and four rows each will result in a relation with ______ columns and ______ rows.
(A) 4, 16
(B) 4, 8
(C) 4, 4
(D) 2, 8

Show Answer/Hide

Answer – (A)

75. Which of the following constraints in relational databases is used to enforce referential integrity ?
(A) NOT NULL
(B) FOREIGN KEY
(C) UNIQUE
(D) PRIMARY KEY

Show Answer/Hide

Answer – (B)

76. Which of the following is a DDL SQL command ?
(A) UPDATE
(B) DELETE
(C) INSERT
(D) ALTER

Show Answer/Hide

Answer – (D)

77. The ______ database tables, contain all the rows which are common in both tables.
(A) Cartesian product
(C) intersection
(B) join
(D) union

Show Answer/Hide

Answer – (C)

78. Which of the following is the correct SQL query that fetches the different ‘surname’ from employee’ table without any duplicate values ?
(A) SELECT UNIQUE surname FROM employee
(B) SELECT DUPLICATE surname FROM employee
(C) SELECT DIFFERENT surname FROM employee
(D) SELECT DISTINCT surname FROM employee

Show Answer/Hide

Answer – (D)

79. Which of the following is not a Relational Database Management System ?
(A) Oracle
(B) MongoDB
(C) MySQL
(D) MS-SQL Server

Show Answer/Hide

Answer – (B)

80. What is 2’s compliment of the binary number 00110001 ?
(A) 01001111
(B) 11001111
(C) 01001110
(D) 11001110

Show Answer/Hide

Answer – (B)

Leave a Reply

Your email address will not be published.

error: Content is protected !!