databases basics

Which field is the best fit to be a primary key?

• FilmName

• FilmID

• AverageRating

• Director

$789.00 is an example of which data type

• Text

• Currency

• Boolean

• Decimal

A row in a database.

• Record
• Field
• Entity
• Table

A column in a database.

• Field
• Record
• Entity
• Validation

Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...

• Data Types
• Filters
• Sorts
• Validations

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

What is a database?

• A piece of software to do calculations
• A device to load information onto the computer.
• A structured collection of information
• A calculator

One of the members of the Sports Club has decided to resign.  What would the secretary do with the record for that member on the database?

• Amend the record
• Delete the field
• Delete the record
• Delete the file

The Sports Club has had an Open Day and has gained a new member.  How will they add their details to the database?

• Add another field
• Amend a record
• Add a new record
• Delete a record

Which of the following is an example of a field?

• 347

• ChannelType

• 351, Nature, Documentary, Bling, False