quiz

Functional Dependencies in DBMS

1. What defines a functional dependency in a relational database?

  • A) A relationship between two tables
  • B) A constraint that ensures unique values in a column
  • C) A mathematical function used to calculate values
  • D) A relationship between attributes where the value of one uniquely determines the value of another
D) A relationship between attributes where the value of one uniquely determines the value of another Explanation

2. What is a candidate key in the context of functional dependencies?

  • A) A key that can only be used for foreign key relationships
  • B) An attribute that is part of a composite key
  • C) A minimal super key for a relation
  • D) An attribute that has no functional dependencies
C) A minimal super key for a relation Explanation

Quick Links