Module 5 Database

1. How would you alter a field to allow up to 20 characters to be entered

By changing the font size

By changing the field size

By changing the data type

By setting a primary key

2. How would you alter a field to allow up to 20 characters to be entered:

By changing the font size

By changing the field size

By changing the data type

By setting a primary key

3. Indexing allows:

Data type to be changed

Speed of searching and sorting of records to be increased

Field sizes to be changed

Queries to be run

4. Which one of the following is responsible for providing users with access to the appropriate data

A database administrator.

A database architect

A database designer

A database user

5. Which one of the following is NOT a common use of a large-scale database?

Bank account records.

Airline reservation

Driver licence records.

Personal address book.

6. Which one of the following describes the content of a database?

A collection of files with no particular link.

A collection of data related to another application.

A collection of data related to a particular subject.

A collection of documents.

7. A collection of data relating to a particular subject is called a:

Table

Macro

Primary key

Field

8. Speed of searching and sorting of records can be increased by:

Changing the data type

Creating a query

Indexing

Changing the field size

9. Tables can be related by:

Defining a primary key

Changing field size