DBMS ONLINE QUIZ - ASSIGNMENT 3 (10 MARKS)
Authored by Veena T
Engineering
Professional Development
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A _________ consists of a sequence of query and/or update statements.
Transaction
Commit
Rollback
Flashback
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following makes the transaction permanent in the database?
View
Commit
Rollback
Transaction
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In order to undo the work of transaction after last commit which one should be used?
View
Commit
Rollback
Flashback
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does Rollback do?
Undoes the transactions before commit
Clears all transactions
Redoes the transactions before commit
No action
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Consider the schedule for transactions T1, T2 and T3:
T1->>T3->>T2
T2->>T1->>T3
T2->>T3->>T1
T3->>T1->>T2
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which one of the following is NOT a part of the ACID properties of database transactions?
Atomicity
Consistency
Isolation
Deadlock
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of these
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
