Home

Which of the following ensures the atomicity of the transaction?

A. Transaction management component of DBMS

B. Application Programmer

C. Concurrency control component of DBMS

D. Recovery management component of DBMS

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

You can do it
  1. As per equivalence rules for query transformation, selection operation distributes over
  2. The keyword to eliminate duplicate rows from the query result in SQL is
  3. The transactions like adding an employee, enrolling a student in a course are examples of _______
  4. A relational database developer refers to a record as
  5. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  6. An advantage of views is
  7. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  8. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  9. The collection of information stored in a database at a particular moment is called as ......
  10. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  11. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  12. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  13. In multiple granularity of locks SIX lock is compatible with
  14. In SQL the statement select * from R, S is equivalent to
  15. DROP is a statement in SQL.
  16. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  17. Which normal form is considered adequate for normal relational database design?
  18. If an entity can belong to only one lower level entity then the constraint is
  19. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  20. The cost of reading and writing temporary files while evaluating a query can be reduced by
  21. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  22. Relations produced from an E-R model will always be
  23. The full form of GUI is _________
  24. Data items grouped together for storage purposes are called a
  25. If the closure of an attribute set is the entire relation then the attribute set is a
  26. Cascading rollback is avoided in all protocol except
  27. Which of the following relational algebraic operations is not from set theory?
  28. Change Staff table by removing default of Assistant for position column
  29. A top-to-bottom relationship among the items in a database is established by a
  30. Which of the following constitutes a basic set of operations for manipulating relational data?