All the changes that were done from a transaction that did not commit before the system crashed, have to be _________

Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and, then apply a 5% interest (i) T1 start (ii) T1 B old = 12000 new = 10000 (ii) T1 M old = 0 new = 2000 (iv) T1 commit (v) T2 start (vi) T2 B old = 10000 new = 10500 (vii) T2 commit Suppose the database system crashed just before log record 7 is written. When the system is restarted, which one statement is true of the recovery procedure?

A

We must redo log record 6 set B to 10500

B

We must undo log record 6 to set B to 10000 and then redo log record 2 and 3

C

We need not redo log records 2 and 3 because transaction T1 has committed

D

We can apply redo and undo operations in arbitrary order because they are idempotent

Consider the following schedule S of transactions T1, T2, T3, T4: T1 T2 T3 T4 Reads(X) Writes(X) Commit Writes(X) Commit Writes(Y) Reads(Z) Commit Reads(X) Reads(Y) Commit Which one of the following statements is CORRECT?

A

S is conflict-serializable but not recoverable

B

S is not conflict-serializable but is recoverable

C

S is both conflict-serializable and recoverable

D

S is neither conflict-serializable not is it recoverable

Two involute gears are designed to mesh for a given centre distance and a given angular velocity ratio (other than 1). During assembly, the centre distance has increased slightly. Then which of the following changes occur? (i) Velocity ratio changes (ii) Pressure angle changes (iii) Pitch circle diameter changes (iv) Working depth changes (v) Base circle radius changes Select the correct answer using the code given below.

A

1, 2 and 3

B

2, 3 and 4

C

2 and 5

D

3 and 5

After several defeats in wars, Robert Bruce went into exile and wanted to commit suicide. Just before committing suicide, he came across a spider attempting tirelessly to have its net. Time and again the spider failed but that did not deter it to refrain from making attempts. Such attempts by the spider made Bruce curious. Thus, Bruce started observing the near-impossible goal of the spider to have the net. Ultimately, the spider succeeded in having its net despite several failures. Such an act of the spider encouraged Bruce not to commit suicide. And then, Bruce went back again and won many a battle, and the rest is history. Which one of the following assertions is best supported by the above information?

A

Failure is the pillar of success

B

Honesty is the best policy

C

Life begins and ends with adventures

D

No adversity justifies giving up hope

Study the following information and select guilty person. Ram was visiting a place where inhabitants always answer any question with two sentences. One of these is always true while other is always false. While on the visit he found that his bag has been stolen and he suspected three persons those visited his guest room. He was sure that only one person is guilty. When he questioned them they replied as follows. R ∶ S did not do it. I did not do it. S ∶ I did not do it. P did not do it. T ∶ I did not do it. I did not know who did it.

A

R

B

S

C

T

D

There is no logical consistency in replies for making decision with respect to given conditions.

Consider the following statements:
1. A person is not guilty of dacoity unless he has committed, attempted to commit or aided in committing robbery.
2. When two persons conjointly commit robbery, every person so committing robbery is said to commit robbery.
Of the above statements

A

1 and 2 are true

B

1 and 2 are false

C

1 is true but 2 is false

D

1 is false but 2 is true

In a database system, unique timestamps are assigned to each transaction using Lamport’s logical clock. Let TS(T1) and TS(T2) be the timestamps of transactions T1 and T2 respectively. Besides, T1 holds a lock on the resource R, and T2 has requested a conflicting lock on the same resource R. The following algorithm is used to prevent deadlocks in the database system assuming that a killed transaction is restarted with the same timestamp. If TS(T2) < TS(T1) then T1 is killed else T2 waits. Assume any transaction that is not killed terminates eventually. Which of the following is TRUE about the database system that uses the above algorithm to prevent deadlocks?

A

The database system is both deadlock-free and starvation-free.

B

The database system is deadlock-free but not starvation-free.

C

The database system is starvation-free, but not deadlock-free.

D

The database system is neither deadlock-free nor starvation-free.

Consider the following statements:
Abetment is constituted by
1. Instigating a person to commit an offence.
2. Engaging in a conspiracy to commit it.
3. Intentionally aiding a person to commit it.
Which of the statements given above are correct?

A

1, 2 and 3

B

1 and 2 only

C

2 and 3 only

D

1 and 3 only

Which of the following statements are correct in relation to criminal conspiracy?
1. When two or more persons agree to do an unlawful act by an unlawful means then they will be guilty of criminal conspiracy
2. Several persons agreed to commit an "offence" but nothing was done in pursuance of the agreement
3. When two or more persons agree to do a lawful act in lawful manner by lawful means but an overt act is done by one them
4. Criminal conspiracy to commit and offence punishable with fine alone will not entail any liability
Select the correct answer:

A

1, 3 and 4

B

2, 3 and 4

C

1, 2 and 4

D

1, 2 and 3

Mundel's classes of change includes
1. Changes in body motions and positions
2. Changes in equipment and working arrangements
3. Changes in production sequence
4. Changes in finished product
5. Changes in raw material

A

1, 2 and 3

B

1, 2, 3 and 4

C

1, 2, 3, 4 and 5

D

None of these

All the changes that were done from a transaction that did not commit before the system crashed, have to be _________

Related Questions