Preview

03 - Files Records and Files

 1. Databases are extremely important applications and most institutions are likely to be using them in one form or the other. A database is __________

  a type of static data structure, identical to a binary tree.

  a collection of stored data, arranged in a logical, structured format

  a type of firmware that contains records, fields and b bytes

  a physical device which stores structured data

 2. Databases are made up of ________________. ___________ are made up of fields.

  data types

  information types

  field types

  records

 3. Fields contain _______

  data types

  validation

  files

  data

 4. A _______________ is simply a table that displays the names of the fields within a record, the type of data and max size of that data.

  duplication check

  record format

  database engine

  field monitoring table

 5. The following is likely to be a record format for a _________________
Student ID    Integer 3 bytes
Name            String 20 bytes
Amount paid    Integer 3 bytes
Passed Course?     Boolean 1 byte

  Student laptop computer purchase

  School course

  Integer type database

  stocks and shares account

 6. There are four key modes of file access. Which of the following are NOT valid modes of access?
serial
binary
sequential
indexed sequential
sentient
random
final

  sentient only

  sequential and indexed sequential

  binary, sentient and final

  serial, binary and sentient

 7. This is a single piece of data such as name, date of birth or telephone number

  record

  field

  file

  database

 8. This is a collection of records, for example a school database

  record

  database

  file

  field

 9. This is one complete set of fields, for example one pupil's school record.

  record

  file

  database

  field

 10. Databases store groups of similar information, like customer information. Databases are divided into ______ which group information so you can search and select more quickly.

  relationships

  database entities

  files

  integrities