1.

What are different data validation approaches?

Answer»

The process of confirming the accuracy and quality of DATA is known as data validation. It is implemented by incorporating various CHECKS into a system or report to ensure that input and stored data are logically consistent. Common types of data validation approaches are

  • Data type check: It confirms that the data entered is of the correct data type.
  • Code check: A code check verifies that a field is chosen from a legitimate list of options or that it corresponds to specific formatting constraints. CHECKING a postal code against a list of valid codes, for EXAMPLE, makes it easier to verify if it is valid.
  • Range check: It ensures that input falls in a predefined range.
  • Format check: Many data types follow a predefined format. Format check confirms that. For example, a date has formats like DD-MM-YY or MM-DD-YY.
  • Consistency check: It confirms that the data entered is logically correct.
  • Uniqueness check: It ensures that the same data is not entered multiple times.


Discussion

No Comment Found

Related InterviewSolutions