Question
Which of the following concurrency control methods
avoids deadlocks entirely but can reduce concurrency by blocking transactions at start?Solution
Conservative 2PL prevents deadlocks by ensuring a transaction obtains all required locks before proceeding; if not available, it waits or aborts, reducing concurrency.
Which of the following is an example of a NoSQL database?
Which SQL command is used to remove a table from the database?
What will be the output of the following Python code:
a=[1,2,3,4,5,6]
print(a[-1],a[-1:],a[:-1])
When implementing a `Graph` traversal algorithm like Depth-First Search (DFS) recursively, what is the primary control flow mechanism that manages the o...
A programmer is trying to debug an issue where an `ArrayList` (or equivalent dynamic array) in their Java/Python code unexpectedly throws an `IndexOut...
Consider the following pseudo-code:Â
 ```
  function calculate(arr):
    sum = 0
    for i from 0 to l...
An SQL `VIEW` is a:
Which of the following is used to enforce referential integrity?
In a relational schema, which normal form eliminates transitive dependencies (i.e., non-prime attribute depends on another non-prime attribute)?
Consider a scenario in an OOP application where a `NullPointerException` (or equivalent) occurs when trying to access a member of an object. What is the...
