IT Fundamentals+ Module 2 Unit 4 Using Databases

IT Fundamentals+ Module 2 Unit 4 Using Databases

Multiple Choice

21. Which of the following describes the main use for a report?

• Compile information for printing.

• Display and maintain records.

• Extract and change data.

• Share data between databases.

Multiple Choice

20. What should be used to display and maintain records in a table?

• Filters

• Forms

• Queries

• Reports

Multiple Choice

19. What is a query used for in a database?

• Compile information for printing.

• Display and maintain records.

• Extract and analyse data.

• Store records and fields.

Multiple Choice

18. Which one of the following is responsible for recovery of data after a database crash?

• A database administrator.

• A database architect.

• A database end user.

• A database specialist.

Multiple Choice

17. Which one of the following makes specific data available for database users?

• A database administrator.

• A database architect.

• A database specialist.

• Database users.

Multiple Choice

16. Which of the following carries out data maintenance and information retrieval in a database?

• Database administrators.

• Database architects.

• Database specialists.

• Database users.

Multiple Choice

15. Which one of the following plan and build professional databases?

• A database administrator.

• A database architect.

• A database end user.

• A database specialist.

Multiple Choice

14. Why is it important to maintain the integrity of relationships between tables?

• Because it prevents related data from being changed or deleted.

• Because it stops creation of duplicate data.

• Because it will make searches in the related tables faster.

• Because it reduces the need to index related tables.

Multiple Choice

13. What is created by matching a unique field in a table with a field in another table?

• A query

• A relationship

• An index.

• A data type

Multiple Choice

12. What is the main purpose of relating data between tables in a database?

• To enable faster data searches.

• To minimise duplication of data.

• To optimise filtering of records.

• To prevent the need for using queries.

Multiple Choice

11. Which could happen if a data type is changed in an existing table?

• Data could be lost.

• Fields could be removed.

• Records could be hidden.

• Tables could be locked.

Multiple Choice

10. What could be used to find and sort records faster?

• A form.

• A primary key.

• A validation rule.

• An index.

Multiple Choice

9. What is used when there is a need to uniquely identify each record in a table?

• A default value.

• A filter.

• A primary key.

• A validation rule.

Multiple Choice

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

• Caption

• Default value

• Field size

• Format

Multiple Choice

7. Which of the following is an appropriate data type for a field containing decimal values?

• AutoNumber

• Number

• Short Text

• Memo

Multiple Choice

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

• Each field in a table should contain a primary key.

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

• Each field in a table should use the same data type.

• Each field in a table should use the same field size.

Multiple Choice

5. What is important when designing a database?

• A form should enter data into multiple tables.

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

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

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

Multiple Choice

4. Which of the following is a common use of large-scale databases?

• Storing and accessing bank account records.

• Storing and accessing bookmarks in a Web browser.

• Storing and accessing contacts in a mobile phone.

• Storing and accessing videos on a hard drive.

Multiple Choice

3. How is a database organised?

• A database contains forms and reports stored in tables.

• A database contains indexes and criteria stored in tables.

• A database contains reports and fields stored in tables.

• A database contains fields and records stored in tables.

Multiple Choice

1. What is a database?

• A data structure that improves search operations in a table.

• A program for creating online forms.

• A set of instructions used when retrieving data from a table.

• A structured collection of records or data.