Which of the following data integrity rules ensures that a field contains a value if it is required?
Data format
Range
Consistency
Completeness
Correct Answer:
Option (2) Range is the correct answer because under the range the field contains a value. The range can be calculated by using the formula that is the larger value minus smaller value. For example if there are 8,9 ,7 ,11, 15,20 , then range is 20 - 8 is 11.
Incorrect Answers:
Option (1) Data format is an incorrect answer because under this data can be arranged in suitable form as per business requirement.There are variouse data formats are available.
Option (3) Consistency is an incorrect answer because data used in format must be consistent and it data is inconsistent then decisions may get false results.
Option (4) Completenes is an incorrect answer because the data which is gathered and collected should be complete is all aspect.
So correct answer is an option (2) or Range
Get Answers For Free
Most questions answered within 1 hours.