Databases

What is a database?

• A structured collection of records or data.

• A workbook in a spreadsheet.

• A messy collection of records or data.

• A PowerPoint presentation

Which of the following is not a computerised database?

• Airline booking system

• Telephone Directory

• Bank account records

• Government records

A field containing a unique value is known as?

• Prime Key

• Unique Key

• First Key

• Primary Key

An Index is used to

• Duplicate data.

• Quickly locate data without having to search every row.

• Decrease the speed of data retrieval.

• Create a list with a lot of information.

What is a relationship in database?

• A system to encourage missing data.

• A collection of irrelevant data merged together.

• Rather than having data organised in a single table, the data will be organised in separate tables.

• A system which is takes up a lot of useful space.

What is important when designing a database?

• A table should contain data related to multiple subject types.

• Always design the database in a colourful manner.

• Make sure you include different font sizes and types.

• A table should contain data related to a single subject type.

What is an important fact when creating fields in a database?

• None of the following.

• Each field in a table should contain several types of data.

• Each field in a table should contain only one type of data.

• Each cell is unique.

Name an appropriate data type for a field containing decimal values.

• Text

• Number

• Calculated

• Date/Time

What property is used to automatically enter a specific field value for new records?

• Random Value.

• Auto Value.

• None of the following.

• Default value.

What could happen if a data type is changed in an existing table?

• Data will be duplicated.

• Data will be saved.

• Data could be lost.

• Data will be stored in a different database.