PGT Computer Science (Level-3), (HTET Practice MCQs) (Part-II)

Total Questions: 100

81. Software safety is a _____________ activity that focuses on the identification and assessment of potential hazards that may affect software negatively and cause an entire system to fail.

Correct Answer: B. Software quality assurance

82. The "PROJECT" operator of a relational algebra creates a new table that has always

Correct Answer: C. Same number of rows as the original table

83. The employee information of an Organization is stored in the relation:

Employee (name, sex, salary, deptname)
Consider the following SQL query
Select deptname from Employee
Where sex = 'M'
group by deptname
having avg (salary) > {select avg (salary) from Employee}
Output of the given query corresponds to

Correct Answer: D. Average salary of male employees in a department is more than average salary of the organization.

84. For a database relation R (a, b, c, d) where the domain of a, b, c, d include only the atomic values. The functional dependency a → c, b → d holds in the following relation

Correct Answer: A. In INF not in 2NF

85. Identify the circumstances under which pre-emptive CPU scheduling is used:

(a) A process switches from Running state to Ready state
(b) A process switches from Waiting state to Ready state
(c) A process completes its execution
(d) A process switches from Ready to Waiting state
Choose the correct option:

Correct Answer: A. (a) and (b) only

86. Solve the equation?

Correct Answer: C. x² - x - 1 = 0

87. The solution of recurrence relation,

Correct Answer: D. O (log n log log n)

88. In any n-element heap, the number of nodes of height h is

Correct Answer: D.

89. A data file of 1,00,000 characters contains only the characters g-l, with the frequencies as indicated in table:

Using the variable-length code by Huffman codes,
the file can be encoded with

Correct Answer: D. 2,24,000 bits

90. Solve the question?

Correct Answer: C. If (u, v) ∈ E, then u ∈ V₁ or v ∈ V₁