WorksheetsDBMS ONLINE QUIZ - ASSIGNMENT 3 (10 MARKS)
Total questions: 10
Worksheet time: 5mins
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
