databases Flashcards
1
Q
4 types of validation
A
presence check- ensures essential fields are not empty
restricted choice- limits selection from a predefined set of options
field length- check data doesn’t exceed a maximum length or meets a set length
range- verifies numerical data falls within a specific range of acceptable values
2
Q
wildcard symbol for multiple characters
A
%
3
Q
wildcard symbol for 1 character
A
_
