What do you understand by data validation? what is the role of field properties in this process? | question and answer !



Question:-

What do you understand by data validation? what is the role of field properties in this process?

Answer:-

Data validation : is a process to specify restrictions on data that users can enter into a field by creating a validation rule. It ensures that a database operates on clean, corret and meaningful data.

Field properties : allow us to specify a valid set of rules as per which data is validated before it is stored in a table.

hence, field properties act as the instruments of data validation.

No comments