Functional Dependencies (FDs)

Loading, please wait ...

Open its course - Database Systems

Topic Questions: 21
MCQs	T/F	FiB	SQ
9	5	7	0

Question Type Legends
	Easy		Medium		Difficult

MCQs T/F FiB Short Qs

Open its course - Database Systems

×
Hidden Questions!

Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.
1 If A, B and C are attributes in a relation, and A is a primary key, then what type of the dependency is this if B dependent on A as well as C dependent on A?
1. Full functional dependency
2. Partial dependency
3. Transitive dependency
4. None of above
- View Answer
2 In dependency structure, A -> B represents:
1. B determines A
2. A functionally dependent on B
3. B functionally dependent on A
4. None of above
- View Answer
3 If A, B and C are attributes in a relation, and A is a primary key, then what type of the dependency is this if B dependent on A as well as C dependent on A?
1. Full functional dependency
2. Partial dependency
3. Transitive dependency
4. None of the above
- View Answer
4 The attribute, or group of attributes, on the left-hand side of the arrow of a functional dependency is called:
1. Dependent
2. Determinant
3. Left side Constraint
4. Primary Key
- View Answer
5 Which of the following is not a characteristic of the functional dependency?
1. One to one relationship
2. Hold for all time
3. Maximum number of attributes
4. Minimal number of attributes
- View Answer

Subject Expert