Q9,p3,d14. __________ rules used to limit the volume of log information that has to be handled and processed in the event of system failure involving the loss of volatile information.

(A) Write-ahead log (B) Check-pointing

(C) Log buffer (D) Thomas

Answer B.

Q8,p3,d14. Which of the following is correct ?

I. Two phase locking is an optimistic protocol.

II. Two phase locking is pessimistic protocol

III. Time stamping is an optimistic protocol.

IV. Time stamping is pessimistic protocol.

(A) I and III (B) II and IV

(C) I and IV (D) II and III

Answer D.

Q 7,p3,d14. Location transparency allows :

I. Users to treat the data as if it is done at one location.

II. Programmers to treat the data as if it is at one location.

III. Managers to treat the data as if it is at one location.

Which one of the following is correct ?

(A) I, II and III (B) I and II only

(C) II and III only (D) II only 
Answer A.

Q6,p3,d14. Specify the contents of the accumulator and the status of the S, Z and CY flags when 8085.microprocessor performs addition of 87 H and 79 H.

(A) 11, 1, 1, 1 (B) 10, 0, 1, 0

(C) 01, 1, 0, 0 (D) 00, 0, 1, 1 .

Answer D.

10000111

01111001

00000000

Sum is written in hexadecimal form as 00.

Carry =1 , flag is set.

Zero flag is set.

               

Q5,p3,D14. How many times will the following loop be executed ?

LXI B, 0007 H

LOP : DCX B

MOV A, B

ORA C

JNZ LOP

(A) 05 (B) 07

(C) 09 (D) 00

Answer b

Explanation.

LXI B,0007H ;Load register pair B with 00H and C with 07H.

A is set with B Values.

OR with A and C  now accumulator contains 07h.

Result is not zero  it loops again

Now DCX reduce value of c as 06.

A is set with 0.

ORA C sets  A as 06

It agains loop.

Similarly it loops till the A value is 0.