Database Basics

From the smallest to the largest, what is the correct order of Database Objects
1. Fields, Files, Records
2. Fields, Records, Files
3. Records, Fields, Files
4. Records, Files, Fields
In the School database, the Head teacher wants a list of all the boys in the 3rd Year.
This would be an example of :-
1. A Simple Search
2. A Complex Search
3. A Simple Sort
4. A Simple Sort
An estate agent keeps a Database of houses for sale. The best way to find the most expensive house would be to :-
1. Search on the "Town" field
2. Sort on the "Town" field
3. Search on the "Price" field
4. Sort on the "Price" field
The Data Protection Act (1984) states that
1. Data must be secure
2. Only relevant data may be stored
3. The Data Subject has the right to see the Data
4. Data should be deleted when no longer required
A database file is made up of 3000 records, each record occupies about 0.4 Kilobytes of Disc space.
How much memory is needed to store this database?
1. 1.2 KiloBytes
2. 12 KiloBytes
3. 120 KiloBytes
4. 1.2 MegaBytes
A Database contains which of the following
1. Fields
2. Records
3. Files
4. Cells
A Borders Estate Agent keeps a Database of houses for Sale.
To find all the houses in Selkirk, he could
1. Search on the "Town" field
2. Sort on the "Town" field
3. Search on the "Price" field
4. Sort on the "Price" field
In a school Database, all the Information about a particular pupil would be
1. A Field
2. A Record
3. A File
4. A Card
Using a Database to find all the pupils in 4th year would be an example of :-
1. A Simple Sort
2. A Simple Search
3. A Complex Sort
4. A Complex Search
In a School Database, a teacher wants to find which pupils use a bus to get to School. When he has found the correct information, the fields he looks at are 'Forename', Surname', 'Class' and 'Travel'.
These fields would be called the :-
1. Search Criteria
2. Sort Criteria
3. Search Fields
4. List Fields
In a database, you could type in peoples ages and edit them every year.
A better way is to type in their date of birth and then get the Computer to work out their age.
In this case, the AGE field would be an example of :-
1. A Formatted Field
2. A Justified Field
3. An Access Field
4. A Calculated Field
In a school Database, someones Surname could be an example of :-
1. A Field
2. A record
3. A File
4. An Integer

Database Basics

Multiple-Choice Exercise