Home

A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.

A. Sub

B. Parent

C. Candidate

D. Super

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

Series MCQ World History MCQ Nuclear Physics MCQ Races and Games MCQ Rearrangement Set 10 MCQ Fluid Mechanics MCQ Php Programming MCQ Phylum - Echinodermata MCQ Botany and Human Welfare MCQ Chemical Kinetics MCQ Height and Distance MCQ Choosing the correct sentence MCQ

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

Submit
Load More..
You can do it
  1. An advantage of views is
  2. The middleware databases in which the business rules act are applicable to _______ tier architectures
  3. A logical schema
  4. The rule that a value of a foreign key must appear as a value of some specific table is called a
  5. In an E-R diagram double lines indicate
  6. Relations produced from an E-R model will always be
  7. For correct behaviour during recovery, undo and redo operation must be
  8. The collection of information stored in a database at a particular moment is called as ......
  9. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  10. In E-R Diagram total participation is represented by
  11. The keyword to eliminate duplicate rows from the query result in SQL is
  12. E-R Modeling is achieved by using ____ diagrams
  13. Cascading rollback is avoided in all protocol except
  14. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  15. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  16. A _____ is used to define overall design of the database
  17. Which of the following is not a characteristic of a relational database model?
  18. The cost of reading and writing temporary files while evaluating a query can be reduced by
  19. Which of the following is not a logical database structure?
  20. Maximum height of a B+ tree of order m with n key values is
  21. According to the levels of abstraction, the schema at the intermediate level is called
  22. Protection of data from unauthorized Disclosure results in loss of _______
  23. If both the functional dependencies : Xï®Y and Yï®X hold for two attributes X and Y then the relationship…
  24. Which two files are used during operation of the DBMS?
  25. DBMS helps achieve
  26. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  27. In 2NF
  28. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  29. The metadata is created by the
  30. Union operator is a :