KPPSC Assistant Director IT PAST PAPER 2022

The amount of time that a job waits in a ready queue for getting selected by the CPU is called?

1. Waiting time
2. Turnaround time
3. Completion time
4. Submission Time

Computer errors caused due to incorrect input data or unreliable programs are often referred to as

1. IPO
2. GIGO
3. ABC
4. None of these

3x8 decoder will have:

1. 4 outputs
2. 5 outputs
3. 6 outputs
4. 8 outputs

What minimum number of bits is required to store the Hexadecimal number FF?

1. 16
2. 12
3. 8
4. 19
5. 4

Data Integrity means:

1. Correctness
2. Consistency
3. Redundancy
4. Both A & B

Storing same data on multiple locations is called:

1. Integrity
2. Security
3. Redundancy
4. None of these

In a table composite key consists of _______ attribute (s).

1. More than one
2. One
3. Two
4. One & Two

____ normal form removes transitive dependency.

1. First
2. Third
3. Second
4. BCNF
5. None of these

Which join refers from the write table that have no matching key in the left table are included in the result set?

1. Left Outer Join
2. Right Outer Join
3. Full Outer Join
4. Half Outer Join

_________ rollback requires the system to maintain additional information about the state of all the running transactions.

1. Partial
2. Total
3. Time
4. Commit
5. All of these