Home

Wait-for graph is used for

A. detecting view serializability.

B. detecting conflict serializability.

C. deadlock prevention

D. deadlock detection

Correct Answer : D.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

Also checkout these categories

Organic Chemistry MCQ Thermodynamics MCQ Chemical Engineering Thermodynamics MCQ Botany and Human Welfare MCQ Rotational Motion MCQ Man and Environment MCQ Microsoft Word MCQ Circulatory System MCQ Course of Action MCQ Anatomy of flowering plant MCQ Angiosperms (Embryology Life Cycles) MCQ Botany MCQ

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

Submit
Load More..
You can do it
  1. Data independence means
  2. Change Staff table by removing default of Assistant for position column
  3. A logical schema
  4. The data in the database at a particular moment of time is called the _______
  5. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  6. The statement that is executed automatically by the system as a side effect of the modification of the…
  7. What is data integrity?
  8. The common column is eliminated in
  9. Isolation of the transactions is ensured by
  10. According to the levels of abstraction, the schema at the intermediate level is called
  11. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  12. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  13. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  14. Data items grouped together for storage purposes are called a
  15. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  16. Which of the following concurrency control schemes is not based on the serializability property?
  17. _____ command can be used to modify a column in a table
  18. Dependency preservation is not guaranteed in
  19. A table can have only one
  20. If the closure of an attribute set is the entire relation then the attribute set is a
  21. DROP is a statement in SQL.
  22. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  23. ______ keyword is used to find the number of values in a column.
  24. The drawback of shadow paging technique are
  25. A top-to-bottom relationship among the items in a database is established by a
  26. Which one is true statement :
  27. The collection of information stored in a database at a particular moment is called as ......
  28. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  29. Which of the following relational algebraic operations is not from set theory?
  30. Cascading rollback is avoided in all protocol except