mglover7115919
Quiz by , created more than 1 year ago

Quiz on Data Validation, created by mglover7115919 on 12/04/2015.

71
0
0
No tags specified
mglover7115919
Created by mglover7115919 about 9 years ago
Close

Data Validation

Question 1 of 6

2

what are two of the rules for validation?

Select one or more of the following:

  • Data Check.

  • Field length check.

  • File check.

  • Input mask.

Explanation

Question 2 of 6

1

We use validation to make sure that data entered into a database is correct?

Select one of the following:

  • True
  • False

Explanation

Question 3 of 6

1

Which of these format checks should validate post codes including ones like CB1 2EU?

Select one of the following:

  • lL09 L00

  • LL09 0LL

  • LL99 L00

  • Ll00 0LL

Explanation

Question 4 of 6

1

A presence check ensures that...

Select one of the following:

  • 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.

Explanation

Question 5 of 6

1

What is an logic error?

Select one of the following:

  • 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.

Explanation

Question 6 of 6

1

What does Real mean in a database?

Select one of the following:

  • 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.

Explanation