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.

You can do it
  1. In SQL the word natural can be used with
  2. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  3. Union operator is a :
  4. Dependency preservation is not guaranteed in
  5. A relational database developer refers to a record as
  6. The common column is eliminated in
  7. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  8. In an E-R diagram double lines indicate
  9. In a relational schema, each tuple is divided into fields called
  10. The middleware databases in which the business rules act are applicable to _______ tier architectures
  11. Wait-for graph is used for
  12. Which of the following is not a characteristic of a relational database model?
  13. Which of the following aggregate functions does not ignore nulls in its results?.
  14. In E-R Diagram total participation is represented by
  15. In an ER model,_____ is described in the database by storing its data.
  16. Isolation of the transactions is ensured by
  17. When an E-R diagram is mapped to tables, the representation is redundant for
  18. _____is a full form of SQL.
  19. Relations produced from an E-R model will always be
  20. Which of the following is not a consequence of concurrent operations?
  21. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  22. _____ First proposed the process of normalization.
  23. Which one is correct statement?Logical data independence provides following without changing application…
  24. If the closure of an attribute set is the entire relation then the attribute set is a
  25. Change Staff table by removing default of Assistant for position column
  26. The metadata is created by the
  27. Which of the following is not comparison operator?
  28. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  29. Which of the following addressing modes permits relocation without any change over in the code?
  30. In SQL, testing whether a subquery is empty is done using