Home

Which of the following is not a consequence of concurrent operations?

A. Lost update problem.

B. Update anomaly.

C. Unrepeatable read.

D. Dirty read.

Correct Answer : B.


Download Objective type questions of DBMS PDF

Get all objective type questions of DBMS MCQ

Also checkout these categories

Reproductive System MCQ Co-Ordination Compound MCQ Development of Biology MCQ Plants Physiology MCQ CorelDraw MCQ Basics of Economics MCQ Problems on Trains MCQ Indirect TAX MCQ Photo-Chemistry MCQ Nuclear Chemistry MCQ Decimal Fraction MCQ Endocrine System MCQ

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

Submit
Load More..
You can do it
  1. For correct behaviour during recovery, undo and redo operation must be
  2. Which of the following is not comparison operator?
  3. The _____ category includes storage media that can be operated on directly by the computers central…
  4. Isolation of the transactions is ensured by
  5. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  6. ____specifies a search condition for a group or an aggregate.
  7. Data independence means
  8. The data models defined by ANSI/SPARC architecture are
  9. _____ database is used to provide statistical information or summaries of values based on various criteria.
  10. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  11. _____ First proposed the process of normalization.
  12. Maximum height of a B+ tree of order m with n key values is
  13. The normal form that is not necessarily dependency preserving is
  14. The graphical representation of a query is .
  15. Which of the following is not a characteristic of a relational database model?
  16. E-R Modeling is achieved by using ____ diagrams
  17. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  18. Union operator is a :
  19. Change Staff table by removing default of Assistant for position column
  20. A relational database developer refers to a record as
  21. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  22. The normalization was first proposed by .
  23. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  24. The statement that is executed automatically by the system as a side effect of the modification of the…
  25. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  26. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  27. Wait-for graph is used for
  28. Relational Algebra is
  29. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  30. _____ is a utility to capture a continuous record of server activity and provide auditing capability.