Transaction and Concurrency Questions

MCQ bookmark_border

1.

A _________ consists of a sequence of query and/or update statements.

A

Transaction

B

Commit

C

Rollback

D

Flashback

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

2.

Which of the following makes the transaction permanent in the database?

A

View

B

Commit

C

Rollback

D

Flashback

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

3.

In order to undo the work of transaction after last commit which one should be used?

A

View

B

Commit

C

Rollback

D

Flashback

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

4.

What does Rollback do?

A

Undoes the transactions before commit

B

Clears all transactions

C

Redoes the transactions before commit

D

No action

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

5.

In case of any shut down during transaction before commit which of the following statement is done automatically?

A

View

B

Commit

C

Rollback

D

Flashback

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

6.

In order to maintain the consistency during transactions, database provides

A

Commit

B

Atomic

C

Flashback

D

Retain

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

7.

Transaction processing is associated with everything below except

A

Conforming an action or triggering a response

B

Producing detail summary or exception report

C

Recording a business activity

D

Maintaining a data

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

8.

A transaction completes its execution is said to be

A

Committed

B

Aborted

C

Rolled back

D

Failed

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

9.

Which of the following is used to get back all the transactions back after rollback?

A

Commit

B

Rollback

C

Flashback

D

Redo

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

10.

______ will undo all statements up to commit?

A

Transaction

B

Flashback

C

Rollback

D

Abort

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion