Cascading rollback is avoided in all protocol except
Practice Database Rollback Questions –
Cascading rollback is avoided in all protocol except
Database Questions
The graphical representation of a query is ________.
Practice Atomicity Questions –
The graphical representation of a query is ________.
Assume transaction A holds a shared lock R. If transaction B also r
Practice Database Locks Questions –
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
In multiple granularity of locks SIX lock is compatible with <
Practice Database Locks Questions –
In multiple granularity of locks SIX lock is compatible with
Which one is true statement :
Practice Database Locks Questions –
Which one is true statement :
A list consists of last names, first names, addresses and pin codes
Practice Compound Key (DBMS) –
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
If the closure of an attribute set is the entire relation then the
Practice Query Tree (DBMS) Questions –
If the closure of an attribute set is the entire relation then the attribute set is a
Which of the following ensures the atomicity of the transaction?&nb
Practice Database Transaction –
Which of the following ensures the atomicity of the transaction?
A transaction is in __________ state after the final statement has
Practice Database Transaction –
A transaction is in __________ state after the final statement has been executed.
If a transaction T has obtained an exclusive lock on item Q, then T
Practice Database Transaction –
If a transaction T has obtained an exclusive lock on item Q, then T can
Which of the following is not a property of transactions?
Practice Database Transaction –
Which of the following is not a property of transactions?
What are the desirable properties of a decomposition
Practice Database Transaction –
What are the desirable properties of a decomposition
Dependency preservation is not guaranteed in
Practice BCNF Questions –
Dependency preservation is not guaranteed in
R (A,B,C,D) is a relation. Which of the following does not have a l
Practice BCNF Questions –
R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition
The default level of consistency in SQL is
Practice Data Independence (DBMS) –
The default level of consistency in SQL is