ICT C3.5 2022

What is a database?

• An application used to print 3D models.

• An application to process text into well formatted documents.

• A structured collection of data.

• A program for creating graphs based on acquired data.

How is a database organised?

• A database contains formatted queries and reports.

• A database contains fields stored in queries.

• A database contains fields and records stored in tables.

• A database contains sorting criteria stored in tables.

Which of the following is not an example of database application?

• Storing and accessing bank account records.

• Storing and accessing contacts in a smart phone.

• Storing a soft copy of a document on a pen-drive.

• Storing and accessing favourite song titles.

What is the most important design feature when designing a database?

• A table should be related to only one other table.

• A table should contain data about one subject type.

• A query should only fetch data from a single report.

• A report should contain records based on a single data type.

What is the difference between data and information?

• Data is stored as numbers while information is stored as text.

• Data is raw facts while information is data processed in a meaningful way.

• Data is generated by computers while information is created by humans.

• Data is presented in alphanumeric characters while information is presented in numeric digits.

Which of the following is important when creating fields in a database?

• A table should contain at least 3 fields.

• Each table should contain a primary key field.

• A field can be of type numeric and of type text at the same time.

• All the fields in a table should be of the same data type.

Which of the following is the most appropriate data type for a field called ClientSurname?

• AutoNumber

• Number

• Short Text

• Memo

What property is used to set a field automatically to a specific value when creating new records?

• Default value

• Yes/No

• Format

• Field size

What can identify a record in a unique way?

• A default value

• A filter

• A validation rule

• A primary key

Which one is used to quickly locate data without having to search every row in a table every time a table is accessed?

• A report

• A primary key

• A One-to-Many relationship

• An index