DBMS-Function Dependency and Decomposition Questions and Answers

Practice Mode
Showing 10 of 39 questions
Q1
Functional dependeny allows the database designer to express facts about the enterprise that the designer is modelling with the enterprise database.
  • A TRUE
  • B FALSE
Answer: Option A
Q2
A functional dependency is a many-to-many relationship between two sets of attributes X and Y of a given table T.
  • A TRUE
  • B FALSE
Answer: Option B
Q3
The term full functional dependency (FFD) is used to indicate the maxmimum set of attributes in a determinant of a functional dependency (FD).
  • A TRUE
  • B FALSE
Answer: Option B
Q4
A functional dependency in the set is redundant if it can be derived from the other functional dependencies in the set.
  • A TRUE
  • B FALSE
Answer: Option A
Q5
A closure of a set (also called complete sets) of functional dependency defines all the FDs that can be derived from a given set of FDs.
  • A TRUE
  • B FALSE
Answer: Option A
Q6
A functional decomposition is the process of breaking down the functions of an organization into progressively greater (finer and finer) levels of detail.
  • A TRUE
  • B FALSE
Answer: Option A
Q7
The word loss in losseless refers to the loss of attributes.
  • A TRUE
  • B FALSE
Answer: Option B
Q8
The dependencies are preserved because each dependency in F represents a constraint on the database.
  • A TRUE
  • B FALSE
Answer: Option A
Q9
If decomposition is not dependency-preserving, some dependency is lost in the decomposition.
  • A TRUE
  • B FALSE
Answer: Option A
Q10
A functional dependency is a
  • A many-to-many relationship between two sets of attributes
  • B one-to-one relationship between two sets of attributes.
  • C many-to-one relationship between two sets of attributes
  • D none of these.
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test