Home

For correct behaviour during recovery, undo and redo operation must be

A. Commutative

B. Associative

C. idempotent

D. distributive

Correct Answer : C.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

Also checkout these categories

Neurology MCQ Phylum - Porifera MCQ Syllogism MCQ Statement & Assumption MCQ Choosing the correct sentence MCQ Decimal Fraction MCQ PageMaker MCQ Strength of Materials MCQ Multimedia and Graphics MCQ Digestive System MCQ Data Sufficiency MCQ Organic Chemistry MCQ

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

Submit
Load More..
You can do it
  1. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  2. Which one is correct statement?Logical data independence provides following without changing application…
  3. ………………… approach reduces time and effort required for design…
  4. If the closure of an attribute set is the entire relation then the attribute set is a
  5. Which of the following is true for network structure?
  6. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  7. HSAM stands for ……….
  8. Protection of data from unauthorized Disclosure results in loss of _______
  9. In b-tree the number of keys in each node is than the number of its children.
  10. Which is the best file organization when data is frequently added or deleted from a file?
  11. What is data integrity?
  12. The collection of information stored in a database at a particular moment is called as ......
  13. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  14. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  15. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  16. Which of the following is not a recovery technique?
  17. In 2NF
  18. The clause alter table in SQL can be used to
  19. In SQL the word natural can be used with
  20. _____ First proposed the process of normalization.
  21. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  22. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  23. _____ database is used to provide statistical information or summaries of values based on various criteria.
  24. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  25. If an entity can belong to only one lower level entity then the constraint is
  26. Isolation of the transactions is ensured by
  27. The keyword to eliminate duplicate rows from the query result in SQL is
  28. Relationships among relationships can be represented in an-E-R model using
  29. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  30. The data models defined by ANSI/SPARC architecture are