Home

______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

A. Domain Integrity Constraints

B. Referential Integrity Constraints

C. Domain Constraints

D. Entity Integrity Constraints

Share this question with your friends

Correct Answer : B.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

Also checkout these categories

Analogy MCQ State of Matter MCQ Design of Masonry Structures MCQ Cause & Effect MCQ Electronics MCQ Alkyl and Aryl Halides MCQ Enuresis MCQ Advanced Surveying MCQ Design of Steel Structures MCQ Strength of Materials MCQ Bryophyta MCQ Electricity Fundamentals MCQ

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

Submit
Load More..
You can do it
  1. In E-R Diagram total participation is represented by
  2. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  3. A transaction is in state after the final statement has been executed.
  4. The graphical representation of a query is .
  5. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  6. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  7. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  8. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  9. Relational Algebra does not have
  10. SQL server stores index information in the _____system table
  11. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  12. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  13. Which one is correct statement?Logical data independence provides following without changing application…
  14. In b-tree the number of keys in each node is than the number of its children.
  15. What are the desirable properties of a decomposition
  16. A logical schema
  17. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  18. ______contains information that defines valid values that are stored in a column or data type.
  19. ______is a preferred method for enforcing data integrity
  20. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  21. The metadata is created by the
  22. Which normal form is considered adequate for normal relational database design?
  23. The data models defined by ANSI/SPARC architecture are
  24. Which one is true statement :
  25. Which of the following is not a property of transactions?
  26. Which of the following is not a recovery technique?
  27. Maximum height of a B+ tree of order m with n key values is
  28. In 2NF
  29. Dependency preservation is not guaranteed in
  30. ____ table store information about database or about the system.