Menu

Question Discussion & Solution

MCQ

Q.

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

A

View

B

Commit

C

Rollback

D

Flashback

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

What does Rollback do?

A

Undoes the transactions before commit

B

Clears all transactions

C

Redoes the transactions before commit

D

No action

Discussion

MCQ

2.

In order to maintain the consistency during transactions, database provides

A

Commit

B

Atomic

C

Flashback

D

Retain

Discussion

MCQ

3.

A transaction completes its execution is said to be

A

Committed

B

Aborted

C

Rolled back

D

Failed

Discussion

MCQ

4.

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

A

Commit

B

Rollback

C

Flashback

D

Redo

Discussion

MCQ

5.

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

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs