December 2014 - Paper 3

6:  
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

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



7:  
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 ofthe following is correct ?
A.

I, II and III

B.

I and II only

C.

II and III only

D.

II only

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



8:  

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

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



9:  

------------------ 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

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



10:  
Let R = ABCDE is a relational scheme with functional dependency set F = {A -> B, B ->C,AC -> D}. The attribute closures of A and E are
A.

ABCD, Ø

B.

ABCD, E

C.

ɸ , Ø

D.

ABC, E

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here: