×

Multiple-Choice Questions

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Management MCQs

More

DBMS Inference Rule (IR) MCQs

DBMS Inference Rule (IR) MCQs: This section contains multiple-choice questions and answers on Inference Rule (IR) in DBMS.
Submitted by Anushree Goswami, on April 01, 2022

1. Inference rules are based on ___.

  1. Armstrong's Axioms
  2. Neilstrong's Axioms
  3. Axioms
  4. None of the above

Answer: A) Armstrong's Axioms

Explanation:

Inference rules are based on Armstrong's Axioms.

Discuss this Question


2. ___ on relational databases can be determined by using Armstrong's axioms.

  1. Functional Independencies
  2. Functional Dependencies
  3. Fractional Independencies
  4. Fraction Dependencies

Answer: B) Functional Dependencies

Explanation:

Functional dependencies on relational databases can be determined by using Armstrong's axioms.

Discuss this Question


3. A type of assertion is the ___ rule.

  1. Interference
  2. Inference
  3. Intraference
  4. Indifference

Answer: B) Inference

Explanation:

The inference rule is a type of assertion. It can apply to a set of FD(functional dependency) to derive other FD.

Discuss this Question


4. From the ___ set, we can infer other functional dependencies.

  1. Last
  2. Middle
  3. Initial
  4. None

Answer: C) Initial

Explanation:

From the initial set, we can infer other functional dependencies.

Discuss this Question


5. How many types of inference rule are there in functional dependency?

  1. 3
  2. 4
  3. 5
  4. 6

Answer: D) 6

Explanation:

There are 6 types of inference rules in functional dependency.

Discuss this Question


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

  1. Reflexive Rule
  2. Augmentation Rule
  3. Transitive Rule
  4. All of the above

Answer: D) All of the above

Explanation:

The types of inference rule in functional dependency are -

  1. Reflexive Rule
  2. Augmentation Rule
  3. Transitive Rule

Discuss this Question


7. Which of the following is not a type of inference rule in functional dependency?

  1. Union Rule
  2. Decomposition Rule
  3. Pseudo Transitive Rule
  4. None of the above

Answer: D) None of the above

Explanation:

The types of inference rules in functional dependencies are -

  1. Union Rule
  2. Decomposition Rule
  3. Pseudo Transitive Rule

Discuss this Question


8. A determines B if B is a ___ of A in the reflexive rule.

  1. Set
  2. Superset
  3. Subset
  4. None

Answer: C) Subset

Explanation:

A determines B if B is a subset of A in the reflexive rule.

Discuss this Question


9. What is the augmentation rule also known as?

  1. Partial Independency
  2. Total Independency
  3. Partial Dependency
  4. Total Dependency

Answer: C) Partial Dependency

Explanation:

Augmentation rule is also known as Partial Dependency.

Discuss this Question


10. If B is determined by A, then ___ is determined by BC regardless of C in the augmentation rule.

  1. AB
  2. A
  3. B
  4. AC

Answer: D) AC

Explanation:

If B is determined by A, then AC is determined by BC regardless of C in the augmentation rule.

Discuss this Question


11. In the case of Transitive Rule, A determines B, and B determines C if B determines A. Therefore, A must also determine ___.

  1. A
  2. B
  3. C
  4. AC

Answer: C) C

Explanation:

In the case of Transitive Rule, A determines B, and B determines C if B determines A. Therefore, A must also determine C.

Discuss this Question


12. Union rule states that if A decides B and A decides C, then A must also decide ___.

  1. A and C
  2. B and C
  3. A and B
  4. None of the above

Answer: B) B and C

Explanation:

Union rule states that if A decides B and A decides C, then A must also decide B and C.

Discuss this Question


13. What is the Decomposition Rule also known as?

  1. Unproject Rule
  2. Determined Rule
  3. Composite Rule
  4. Project Rule

Answer: D) Project Rule

Explanation:

Decomposition Rule is also known as Project Rule.

Discuss this Question


14. ___ says when A and B are determined by the same process, then A and B are determined separately.

  1. Project Rule
  2. Decomposition Rule
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

Decomposition Rule or Project Rule says when A and B are determined by the same process, then A and B are determined separately.

Discuss this Question


15. If A determines B, and BC determines D, then AC determines D according to the ___ Rule.

  1. Transitive Rule
  2. Pseudo Rule
  3. Pseudo Decomposition Rule
  4. Pseudo Transitive Rule

Answer: D) Pseudo Transitive Rule

Explanation:

If A determines B, and BC determines D, then AC determines D according to the Pseudo transitive Rule.

Discuss this Question


16. If A → B and BC → D then ___.

  1. AB → D
  2. D → AB
  3. AC → D
  4. D → AC

Answer: C) AC → D

Explanation:

If A → B and BC → D then AC → D.

Discuss this Question


17. If A → __ then A → B and A → C.

  1. A →C
  2. A → AC
  3. A → AB
  4. A → BC

Answer: D) A → BC

Explanation:

If A → BC then A → B and A → C.

Discuss this Question


18. If A → B and A → ___ then A → BC.

  1. A
  2. B
  3. C
  4. None

Answer: C) C

Explanation:

If A → B and A → C then A → BC.

Discuss this Question


19. If ___ → B and B → C then A → C.

  1. A
  2. B
  3. C
  4. None

Answer: A) A

Explanation:

If A → B and B → C then A → C.

Discuss this Question


20. If A → B then ___ → BC.

  1. AB
  2. AC
  3. BC
  4. None

Answer: B) AC

Explanation:

If A → B then AC → BC.

Discuss this Question


21. If A ⊇ B then A → ___.

  1. NULL
  2. 0
  3. 1
  4. B

Answer: D) B

Explanation:

If A ⊇ B then A → B.

Discuss this Question





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.