DBMS ONLINE QUIZ - ASSIGNMENT 3 (10 MARKS)

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

• Transaction

• Commit

• Rollback

• Flashback

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

• View

• Commit

• Rollback

• Transaction

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

• View

• Commit

• Rollback

• Flashback

What does Rollback do?

• Undoes the transactions before commit

• Clears all transactions

• Redoes the transactions before commit

• No action

Consider the schedule for transactions T1, T2 and T3: 

• T1->>T3->>T2

• 
  T2->>T1->>T3

• T2->>T3->>T1

• T3->>T1->>T2

Which one of the following is NOT a part of the ACID properties of database transactions?

• Atomicity

• Consistency

• Isolation

• Deadlock

Database locking concept is used to solve the problem of

• Lost Update

• Uncommitted Dependency

• Inconsistent Data

• All of these

A transaction completes its execution is said to be

• 
  Saved

• Lodded

• rolled

• Committed

A transaction for which all committed changes are permanent is called:

• 
  atomic

• 
  consistent

• 
  isolated

• durable

A shared lock allows which of the following types of transactions to occur?

• Delete

• Insert

• Read

• Update