Home » MCQs » DBMS MCQs

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

---

---