Normalization

Open its course - Database Systems

Topic Questions: 48
MCQs	T/F	FiB	SQ
22 5 17	12 3 9	11 1 10	3 0 3

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. We recommends them to have more than 70+ questions against the topic and make them public.
1 Which type of dependency is removed in 2nd normal form to make the relation(s) full functional dependent:
1. Full functional dependency
2. Partial dependency
3. Transitive dependency
4. None of above
- View Answer
2 One goal to eliminate various anomalies in relational database is to:
1. Reduce attributes
2. Reduce tables
3. Increase data
4. Reduce storage space
- View Answer
3 _____________ is the most efficient method to reduce the duplication of data.
1. Deletion
2. Normalization
3. Alter
4. none of the above
- View Answer
4 For some relations, updating the data can have undesirable consequences called
1. Referential integrity
2. Insertion anamoly
3. Deletion anamoly
4. Modification anamoly
- View Answer
5 A table is in 1NF but not in 2NF if in the table:
1. There are no repeating groups but have partial dependency
2. There are repeating groups
3. There are repeating groups but no transitive dependency
4. None
- View Answer