Home

Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.

A. Functional dependency

B. Multi-valued dependency

C. Transitive dependency

D. Partial dependency

Correct Answer : B.


Download Objective type questions of DBMS PDF

Get all objective type questions of DBMS MCQ

Also checkout these categories

Biological Classification MCQ Decimal Fraction MCQ Simplification MCQ Optics MCQ Structural Organization In Animals MCQ Data Sufficiency MCQ Races and Games MCQ Mechanical Engineering MCQ Electric Current MCQ Plants Physiology MCQ Relativity MCQ Internal Combustion MCQ

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

Submit
Load More..
You can do it
  1. When an E-R diagram is mapped to tables, the representation is redundant for
  2. DROP is a statement in SQL.
  3. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  4. Relational Algebra does not have
  5. _____ database is used to provide statistical information or summaries of values based on various criteria.
  6. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  7. What are the desirable properties of a decomposition
  8. The default level of consistency in SQL is
  9. The values of the attribute describes a particular
  10. DBMS is a collection of _____ that enables user to create and maintain a database.
  11. In 2NF
  12. The data in the database at a particular moment of time is called the _______
  13. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  14. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  15. Which of the following is not a logical database structure?
  16. The part of a database management system which ensures that the data remains in a consistent state is
  17. In b-tree the number of keys in each node is than the number of its children.
  18. As per equivalence rules for query transformation, selection operation distributes over
  19. Which of the following aggregate functions does not ignore nulls in its results?.
  20. Union operator is a :
  21. The _______ is a set of programs to use and / or modify this data.
  22. The statement that is executed automatically by the system as a side effect of the modification of the…
  23. DFD stands for
  24. The keyword to eliminate duplicate rows from the query result in SQL is
  25. Which of the following concurrency control schemes is not based on the serializability property?
  26. The drawback of shadow paging technique are
  27. An advantage of views is
  28. The rule that a value of a foreign key must appear as a value of some specific table is called a
  29. Which is the best file organization when data is frequently added or deleted from a file?
  30. Dependency preservation is not guaranteed in