Which of the following protocols ensures conflict serializability and safety from deadlocks?

Related MCQs

• The three basic techniques to control deadlocks are: deadlock ____, deadlock detection, and deadlock avoidance.
• Deadlocks are possible only when one of the transactions wants to obtain a(n) ____ lock on a data item.
• Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:
• Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:
• Centralizing the integrity checking directly under the DBMS ………….. duplication and ensures the consistency and validity of the database.
• The application program typically communicates with a database server, through                        or other protocols, in order to get or store data.
• Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?
• ____ ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure.
• The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is               false and unknown is            while unknown and unknown is            
• Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?