Data Validation

Description

Quiz on Data Validation, created by mglover7115919 on 12/04/2015.
mglover7115919
Quiz by mglover7115919, updated more than 1 year ago
mglover7115919
Created by mglover7115919 about 9 years ago
71
0

Resource summary

Question 1

Question
what are two of the rules for validation?
Answer
  • Data Check.
  • Field length check.
  • File check.
  • Input mask.

Question 2

Question
We use validation to make sure that data entered into a database is correct?
Answer
  • True
  • False

Question 3

Question
Which of these format checks should validate post codes including ones like CB1 2EU?
Answer
  • lL09 L00
  • LL09 0LL
  • LL99 L00
  • Ll00 0LL

Question 4

Question
A presence check ensures that...
Answer
  • The data is within a given range.
  • The data is text or numeric.
  • Data is entered into the field.
  • The data is entered in a particular format.

Question 5

Question
What is an logic error?
Answer
  • The program would run but it wouldn't run in the why you want it to e.g if the AND / OR re the wrong way round.
  • Doesn't run if the rules are spelt wrong or if the rules aren't entered proper.

Question 6

Question
What does Real mean in a database?
Answer
  • It's a whole number.
  • It's a decimal number.
  • It's a Yes/No, True/False or On/Off.
  • Can be with single quotes, double quotes or triple quotes.
Show full summary Hide full summary

Similar

Higher Level Economics
Jim hammerton
Tsarist Russia 1861 - 1918
emilyyoung212
All math revision
katiehumphrey
Matters of Life and Death GCSE
kate.siena
Chemistry Edexcel C2 topic 1+topic 2 notes
isabellaoliver
Business Studies GCSE
phil.ianson666
AS Media Studies Terminology
Mourad
Spanish foods
JoeBerry99
ALL module 5 vocab
Pamela Dentler
2PR101 1.test - 1. část
Nikola Truong
Mezinárodní ekonomie 2SE221,2SE201 (1)
Filip Wimmer