Database Normalization of Relations Multiple Choice Questions (MCQ) PDF - 40

MCQ 196: The process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as

1. normalization of data
2. denomination of data
3. isolation of data
4. de-normalization of data

MCQ 197: In SQL, the type of character string value which is specified as being case sensitive and placed between apostrophes is called

1. literal string value
2. fixed length string
3. fixed length bit-string
4. literal time stamp

MCQ 198: The main constraints applicable in specialization are

1. disjointness constraint
2. incomplete constraint
3. completeness constraint
4. both a and c

MCQ 199: The type of function which allows performing additional operations and sending messages to other tables in database program is considered as

1. trigger
2. semantics
3. index
4. structure

MCQ 200: The additional access path added into ordered file is called

1. ternary index
2. tertiary index
3. primary index
4. secondary index