Home

Cascading rollback is avoided in all protocol except

A. strict two-phase locking protocol.

B. tree locking protocol

C. two-phase locking protocol

D. validation based protocol.

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

You can do it
  1. Which of the following ensures the atomicity of the transaction?
  2. A logical schema
  3. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  4. ______is a preferred method for enforcing data integrity
  5. For using a specific database …………… command is used.
  6. A relational database developer refers to a record as
  7. It is an abstraction through which relationships are treated as higher level entities
  8. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  9. The clause alter table in SQL can be used to
  10. Change Staff table by removing default of Assistant for position column
  11. The normal form that is not necessarily dependency preserving is
  12. An advantage of views is
  13. Which of the following is not a property of transactions?
  14. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  15. In 2NF
  16. SQL server stores index information in the _____system table
  17. Which normal form is considered adequate for normal relational database design?
  18. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  19. The common column is eliminated in
  20. The metadata is created by the
  21. _____ command can be used to modify a column in a table
  22. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  23. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  24. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  25. Which of the following constitutes a basic set of operations for manipulating relational data?
  26. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  27. The rule that a value of a foreign key must appear as a value of some specific table is called a
  28. The graphical representation of a query is .
  29. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  30. Relational Algebra is