Foxoyo
Hey..!!
Deadlocks DBMS
  Practice
MCQs
Quizzes
About
Leaderboard
Amazon Books
13
MCQs
0
Attempts
0 %
Accuracy
share
Filter by
Type here
Apply
Which of these can not be used for a variable name in Java
none of the mentioned
Keyword
both a < b
identifier
Literals in java must be preceded by which of these
D
L
Both A & B
Which of these is returned by operators &,
Integer
Boolean
float
Character
A deadlock exists in the system if and only if the wait-for graph contains a ___________
Cycle
Bi-direction
direction
rotation
A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set
Waiting
Ready
Idle
Deadlock
Which of these is data type long literal
0x99fffa
99671246
0x99fffL
ABCDEFG
Literal can be of which of these data types
Integer
All of the mentioned
Boolean
float
When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj ). Otherwise, Ti is rolled back
(dies). This is
Wait-wound
wait
Wait-die
Wound-wait
When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti ). This is
Wound-wait
Wait-wound
wait
Wait-die
What are the ways of dealing with deadlock
Deadlock detection
deadlock recovery
All of the mentioned
deadlock prevention
The deadlock state can be changed back to stable state by using _____________ statement
Commit
Deadlock
Savepoint
Rollback
__________ rollback requires the system to maintain additional information about the state of all the running transactions
Total
partial
Commit
Time
The deadlock in a set of transaction can be determined by
Wait graph
Read-only graph
All of the mentioned
Wait-for graph
1
take a quick Quiz
Practice mcqs on Deadlocks DBMS
Let's start
pick difficulty level
all
1
2
3
4
5
13
Mcqs
0
attempts
0
followers
Related Topics
Deadlocks DBMS
Deadlocks
Constraints DBMS
DBMS Keys
Indexes DBMS
Transactions DBMS
Physical Storage Media DBMS
Triggers DBMS
Normal Forms DBMS
RAID DBMS
Suggested Books