Database Review - iGCSE

which data type would you use for a field named "Ticket_cost" ?

• number

• Date

• Boolean

• Currency

which data type would you use for a field named "Already_paid?" ?

• number

• Date

• Boolean

• Currency

which data type would you use for a field named "phone number" ?

• number

• Date

• Boolean

• Currency

• text

Where can you change the data types?

• A

• B

• C

• D

Where can you add validation?

• A

• B

• C

• D

Which of these are true about data validation?

• Validation aims to make sure that data is sensible and reasonable

• Validation aims to make sure that data is within acceptable boundaries

• Validation aims to make sure that data is complete

• Validation aims to make sure that data is all correct

How many records does this table hold?

• 4

• 10

• 5

• 9

How many fields does this table hold?

• 4

• 10

• 5

• 9

What is the data type of the field "interested" ?

• boolean

• text

• date

• number

You want to make sure that the DateOfBirth is before the 01/01/2010.

Where should you type the validation rule?

• Next to the "Validation Rule" box

• Next to the "Validation Text" box

• You should change "required" to yes

• Next to the "Format" box