ADVERTISEMENT
ADVERTISEMENT

DBMS Functional Dependency MCQs

DBMS Functional Dependency MCQs: This section contains multiple-choice questions and answers on functional dependency in DBMS.
Submitted by Anushree Goswami, on March 31, 2022

1. Two attributes can be functionally ___ on/of each other.

  1. Dependent
  2. Independent
  3. Both A and B
  4. None of the above

Answer: A) Dependent

Explanation:

Two attributes can be functionally dependent on each other.

Discuss this Question


2. An attribute that is ___ and the primary key of a table are typically functionally dependent on one another.

  1. Key
  2. Non-Key
  3. One-Key
  4. Many-Key

Answer: B) Non-Key

Explanation:

An attribute that is non-key and the primary key of a table are typically functionally dependent on one another.

Discuss this Question


3. Functional dependencies are classified as ___ on the left.

  1. Dependent
  2. Determined
  3. Determinants
  4. Database

Answer: C) Determinants

Explanation:

Function dependencies are classified as determinants on the left.

Discuss this Question


4. ___ is the right side of making functional dependency.

  1. Determinants
  2. Dependency
  3. Independency
  4. None

Answer: B) Dependency

Explanation:

Dependency is the right side of making functional dependency.

Discuss this Question


5. How many types of functional dependencies are there?

  1. 1
  2. 2
  3. 3
  4. 4

Answer: D) 4

Explanation:

There are mainly four types of Functional Dependency in DBMS:

  1. Trivial functional dependency
  2. Non-Trivial functional dependency
  3. Multivalued functional dependency
  4. Transitive functional dependency

Discuss this Question


6. Which of the following is a type of functional dependency?

  1. Trivial Functional Dependency
  2. Non-trivial Functional Dependency
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

There are mainly four types of Functional Dependency in DBMS:

  1. Trivial functional dependency
  2. Non-Trivial functional dependency
  3. Multivalued functional dependency
  4. Transitive functional dependency

Discuss this Question


7. If ___, then A -> B has trivial functional dependency.

  1. B is a subset of A
  2. A is a subset of B
  3. A is a subset of A'
  4. B is a subset of B'

Answer: A) B is a subset of A

Explanation:

If B is a subset of A, then A -> B has trivial functional dependency.

Discuss this Question


8. Which of the following is a trivial functional dependency?

  1. A->B, if B is a subset of A
  2. A->A
  3. B->B
  4. All of the above

Answer: A) A->B, if B is a subset of A

Explanation:

These are the trivial functional dependencies -

  1. A->B
  2. A->A
  3. B->B

Discuss this Question


9. If ___, then A -> B has non-trivial functional dependency.

  1. B is not a subset of A
  2. A is not a subset of B
  3. A is not a subset of A'
  4. B is not a subset of B'

Answer: A) B is not a subset of A

Explanation:

If B is not a subset of A, then A -> B has non-trivial functional dependency.

Discuss this Question


10. A -> B is a ___l, when A intersection B is NULL.

  1. Complete Trivial
  2. Complete Non-Trivial
  3. Incomplete Trivial
  4. Incomplete Non-Trivial

Answer: B) Complete Non-Trivial

Explanation:

A -> B is a complete non-trivial, when A intersection B is NULL.

Discuss this Question



ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.