Bissoy.com
Doctors Medicines MCQs Q&A

A ROLLBACK TRANSACTION statement specifying a savepoint_name releases any locks that are acquired beyond the savepoint, with the exception of __________

A ROLLBACK TRANSACTION statement specifying a savepoint_name releases any locks that are acquired beyond the savepoint, with the exception of __________ Correct Answer escalations

These locks are not released, and they are not converted back to their previous lock mode.

Related Questions

In a lock making factory, 5 percent of the total produced locks were found defective and 80 percent of the non-defective locks were exported. If 85500 non-defective locks were not exported, then how many locks produced? 
Two statements are given and some conclusions are given as well. Assume the given statements to be true even if they differ from commonly known facts and decide which of the given conclusion(s) is/are logical from the given statements. Statements: I. All houses are locks. II. All locks are shoes. Conclusion: I. Some locks are houses. II. All locks are houses. III. Some shoes are houses. IV. No shoes are houses.
Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
In the question below, there are three statements followed by two conclusions. You have to take the given statements to be true even if they seem to be at variance with commonly known facts and then decide which of the given conclusion logically follow(s) from the given statements. Statements: 1. All keys are locks. 2. All locks are screws. 3. All doors are keys. Conclusions: I. All screws are keys. II. Some locks are keys. 
Two statements are given, followed by two conclusions numbered 1 and 2. Assuming the statements to be true, even if they seem to be at variance with known facts, decide which of the conclusions logically follow(s) from the statements. Statements: All hooks are hangers. Some hangers are locks. Conclusions: 1. Some locks are hangers 2. All locks are hooks.
Statements :
All keys are locks.
All locks are bangles.
All bangles are cars.
Conclusion :
a. Some cars are locks.
b. Some bangles are keys.
c. Some cars are keys.
Statements : Some pots are keys. Some keys are locks. All keys are rings.

Conclusions :
I. Some pots are locks.
II. Some pots are not locks.
III. Some pots are rings.
IV. Some pots are not rings.
Statements : All the locks are keys. All the keys are bats. Some watches are bats.

Conclusions :
I. Some bats are locks.
II. Some watches are keys.
III. All the keys are locks.
Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This is
If a transaction may obtain locks but may not release any locks then it is in _______ phase