Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 1]

    View

  • 2]

    Commit

  • 3]

    Rollback

  • 4]

    Flashback

Solution
No Solution Present Yet

Top 5 Similar Quiz - Based On AI&ML

Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api

# Quiz
1
Discuss

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

  • 1]

    Transaction

  • 2]

    Commit

  • 3]

    Rollback

  • 4]

    Flashback

Solution
2
Discuss

______ will undo all statements up to commit?

  • 1]

    Transaction

  • 2]

    Flashback

  • 3]

    Rollback

  • 4]

    Abort

Solution
3
Discuss

A transaction completes its execution is said to be

  • 1]

    Committed

  • 2]

    Aborted

  • 3]

    Rolled back

  • 4]

    Failed

Solution
4
Discuss

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

Solution
5
Discuss

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

Solution
6
Discuss

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

Solution
7
Discuss

In order to maintain the consistency during transactions, database provides

  • 1]

    Commit

  • 2]

    Atomic

  • 3]

    Flashback

  • 4]

    Retain

Solution
8
Discuss

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

  • 1]

    Commit

  • 2]

    Rollback

  • 3]

    Flashback

  • 4]

    Redo

Solution
9
Discuss

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

  • 1]

    View

  • 2]

    Commit

  • 3]

    Rollback

  • 4]

    Flashback

Solution
# Quiz