50.9k views
5 votes
Under which conditions can a validation rule catch incorrect data?

a. During record creation only
b. During record editing only
c. Both during record creation and editing
d. Only for specific user profiles

User MaGnetas
by
8.1k points

1 Answer

3 votes

Final answer:

Validation rules are designed to catch incorrect data both during the creation of a new record and the editing of an existing record, ensuring data integrity throughout the lifecycle of the record.

Step-by-step explanation:

The condition under which a validation rule can catch incorrect data is c. Both during record creation and editing. Validation rules in database systems, spreadsheets, and software applications are designed to ensure data integrity by preventing the entry of incorrect or invalid data. These rules are triggered any time a record is either created or modified. For example, if a validation rule specifies that a phone number field must contain 10 digits, the rule will check for this requirement whether a new record is being entered or an existing record is being updated.

User Einclude
by
7.9k points