Home

Which one is true statement :

A. With finer degree of granularity of locking a high degree of concurrency is possible.

B. Locking prevents non-serializable schedules.

C. Locking cannot take place at field level.

D. An exclusive lock on data item X is granted even if a shared lock is already held on X.

You can do it
  1. Isolation of the transactions is ensured by
  2. In an E-R diagram double lines indicate
  3. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  4. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  5. A _____ is used to define overall design of the database
  6. Which of the following ensures the atomicity of the transaction?
  7. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  8. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  9. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  10. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  11. Which of the following relational algebraic operations is not from set theory?
  12. Which of the following constitutes a basic set of operations for manipulating relational data?
  13. The _______ is a set of programs to use and / or modify this data.
  14. The graphical representation of a query is .
  15. Tree structures are used to store data in
  16. approach reduces time and effort required for design and lesser risk in database management.
  17. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  18. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  19. The normal form that is not necessarily dependency preserving is
  20. The statement that is executed automatically by the system as a side effect of the modification of the…
  21. The values of the attribute describes a particular
  22. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  23. For correct behaviour during recovery, undo and redo operation must be
  24. If an entity can belong to only one lower level entity then the constraint is
  25. In an ER model,_____ is described in the database by storing its data.
  26. Which of the following concurrency control schemes is not based on the serializability property?
  27. Which one is correct statement?Logical data independence provides following without changing application…
  28. In 2NF
  29. In multiple granularity of locks SIX lock is compatible with
  30. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…