Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

A. It will result in a deadlock situation.

B. It will immediately be rejected.

C. It will immediately be granted.

D. It will be granted as soon as it is released by A .

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. The normalization was first proposed by .
  2. Cascading rollback is avoided in all protocol except
  3. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  4. _____ command can be used to modify a column in a table
  5. The values of the attribute describes a particular
  6. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  7. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  8. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  9. Processed data is called _____
  10. Which one is true statement :
  11. Which of the following addressing modes permits relocation without any change over in the code?
  12. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  13. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  14. In SQL, testing whether a subquery is empty is done using
  15. Change Staff table by removing default of Assistant for position column
  16. Manager salary details are hidden from the employee .This is
  17. If both the functional dependencies : XY and YX hold for two attributes X and Y then the relationship…
  18. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  19. ____specifies a search condition for a group or an aggregate.
  20. In b-tree the number of keys in each node is than the number of its children.
  21. Which of the following is a reason to model data?
  22. Which of the following relational algebraic operations is not from set theory?
  23. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  24. A data type or format is specified for each _________
  25. Data items grouped together for storage purposes are called a
  26. _____is a full form of SQL.
  27. Which of the following is not a logical database structure?
  28. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  29. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  30. The common column is eliminated in