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

Total Questions: 100

51. Blind image deconvolution is ................. .

Correct Answer: A. Combination of blur identification and image restoration

52. A basic feasible solution of a linear programming problem is said to be ................ if at least one of the basic variable is zero.

Correct Answer: A. degenerate

53. Consider the following conditions:

(a) The solution must be feasible, i.e., it must satisfy all the supply and demand constraints.
(b) The number of positive allocations must be equal to m + n - 1, where m is the number of rows and n is the number of columns.
(c) All the positive allocations must be in independent positions.
The initial solution of a transportation problem is said to be non-degenerate basic feasible solution if it satisfies:
Codes:

Correct Answer: D. (a), (b) and (c)

54. Consider the following transportation problem:

The transportation cost in the initial basic feasible
solution of the above transportation problem using
Vogel's Approximation method is:

Correct Answer: B. 1465

55. The character set used in Windows 2000 operating system is .................. .

Correct Answer: C. 16 bit UNICODE

56. In Unix, the command to enable execution permission for file "mylife" by all is ................. .

Correct Answer: D. All of the above

57. What will be the output of the following Unix command?

$rm chap0\[1 - 3\]

Correct Answer: A. Remove file chap0[1 - 3]

58. Which of the following statements regarding the features of the object-oriented approach to databases are true?

(a) The ability to develop more realistic models of the real world.
(b) The ability to represent the world in a nongeometric way.
(c) The ability to develop databases using natural language approaches.
(d) The need to split objects into their component parts.
(e) The ability to develop database models based on location rather than state and behaviour.
Codes:

Correct Answer: A. (a), (b) and (c)

59. Consider the following database table:

Create table test(
one integer,
two integer,
primary key(one),
unique(two),
check(one> = 1 and < = 10),
check(two> = 1 and < = 5)
);
How many data records/tuples atmost can this table contain?

Correct Answer: A. 5

60. Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2:

SQ1: Select *
From R Full Join S
On R.B=S.B;
SQ2: Select *
From R Inner Join S
On R.B=S.B;
The numbers of tuples in the result of the SQL query
SQ1 and the SQL query SQ2 are given by:

Correct Answer: D. 4 and 2 respectively