CameraIcon

SearchIcon

MyQuestionIcon

1

You visited us 1 times! Enjoying our articles? Unlock Full Access!

Pick up the c...

Question

Pick up the correct statements of the following:
P. Weak entity is always having total participation.
Q. Shared and Exclusive locks are released only after commit in rigorous two phase locking protocol.
R. ALL and ANY conditions will return TRUE if inner query return an empty set.

Open in App

Solution

(B)
ALL conditions will return TRUE if inner query returns an empty set but not ANY conditions.

Suggest Corrections

thumbs-up

0

Similar questions

Q. Pick up the correct statements of the following:
P. All conflict serializable schedules are also view serializable schedules.
Q. R1(x), W2(y) are conflict operations
R. Shared and Exclusive locks are released only after commit in strict two phase locking protocol

Q. A multithreaded program P executes with x number of threads and uses y number of locks for ensuring mutual exclusion while operating on shared memory locations. All locks in the program are non-reentrant, i.e., if a thread holds a lock

l

, then it cannot re-acquire lock

l

without relasing it. If a thread is unable to acquire a lock, it blocks unitl the lock becomes available. The minimum value of x and the minimum value of y together for which execution of P can result in a deadlock are:

Q. Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?

I. 2-phase locking II. Time-stamp ordering

Q. Fetch_And_Add(X,i) is an atomic Read-Modify-Write instruction that reads the value of memory location X, increments it by the value i, and returns the old value of X, it is used in the pseudocode shown below to implement a busy-wait lock. L is unsigned integer shared variable initialized to 0. The value of 0 corresponds to lock being available, while any non-zero value corresponds to the lock being not available.

AcquireLock (L) {
while (Fetch_And_Add(L,1))
L = 1;
}
Release Lock (L){
L=0;
}
This implementation

Join BYJU'S Learning Program

similar_icon

Related Videos

lock

Uses and Applications

Watch in App

Join BYJU'S Learning Program

CrossIcon