Home

Isolation of the transactions is ensured by

A. Transaction management

B. Application programmer

C. Concurrency control

D. Recovery management

You can do it
  1. Which of the following concurrency control schemes is not based on the serializability property?
  2. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  3. The _______ is a set of programs to use and / or modify this data.
  4. Shadow paging has
  5. In b-tree the number of keys in each node is than the number of its children.
  6. In an E-R diagram double lines indicate
  7. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  8. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  9. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  10. Which of the following ensures the atomicity of the transaction?
  11. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  12. A _____ is used to define overall design of the database
  13. What is a disjoint less constraint?
  14. The statement that is executed automatically by the system as a side effect of the modification of the…
  15. It is an abstraction through which relationships are treated as higher level entities
  16. Which one is correct statement?Logical data independence provides following without changing application…
  17. Relational Algebra is
  18. DROP is a statement in SQL.
  19. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  20. ______contains information that defines valid values that are stored in a column or data type.
  21. Tree structures are used to store data in
  22. DBMS helps achieve
  23. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  24. Relationships among relationships can be represented in an-E-R model using
  25. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  26. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  27. The data in the database at a particular moment of time is called the _______
  28. Which is the best file organization when data is frequently added or deleted from a file?
  29. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  30. Which of the following is not a recovery technique?