SQL -Structured Query Language - SQL View - Delete View Quiz

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

• 1]

  Transaction

• 2]

  Commit

• 3]

  Rollback

• 4]

  Flashback

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

• 1]

  View

• 2]

  Commit

• 3]

  Rollback

• 4]

  Flashback

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

• 1]

  View

• 2]

  Commit

• 3]

  Rollback

• 4]

  Flashback

Consider the following action:

TRANSACTION.....
Commit;
ROLLBACK;

What does Rollback do?

• 1]

  Undoes the transactions before commit

• 2]

  Clears all transactions

• 3]

  Redoes the transactions before commit

• 4]

  No action

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

• 1]

  View

• 2]

  Commit

• 3]

  Rollback

• 4]

  Flashback

In order to maintain the consistency during transactions, database provides

• 1]

  Commit

• 2]

  Atomic

• 3]

  Flashback

• 4]

  Retain

Transaction processing is associated with everything below except

• 1]

  Conforming an action or triggering a response

• 2]

  Producing detail summary or exception report

• 3]

  Recording a business activity

• 4]

  Maintaining a data

A transaction completes its execution is said to be

• 1]

  Committed

• 2]

  Aborted

• 3]

  Rolled back

• 4]

  Failed

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

• 1]

  Commit

• 2]

  Rollback

• 3]

  Flashback

• 4]

  Redo

______ will undo all statements up to commit?

• 1]

  Transaction

• 2]

  Flashback

• 3]

  Rollback

• 4]

  Abort