\ Free Question's Objective

Time

Email Us

admin@resultjob.com

Database Management System Question

Database Management System Question With Answer & Solution
Que. - A deadlock exists in the system if and only if the wait-for graph contains a                        
Que. -                      rollback requires the system to maintain additional information about the state of all the running transactions.
Que. - If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called
Que. - If a node is locked in                      explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
Que. - If a node is locked in                          then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
Que. - If a node is locked in                              the subtree rooted by that node is locked explicitly in shared mode, and that explicit locking is being done at a lower level with exclusive-mode locks.
Que. - The                      requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.
Que. -                          denotes the largest timestamp of any transaction that executed write(Q) successfully.
Que. - The most recent version of standard SQL prescribed by the American National Standards Institute is
Que. - ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is