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 collection of stored data, arranged in a logical, structured format

  a physical device which stores structured data

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

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

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

  data types

  records

  information types

  field types

 3. Fields contain _______

  files

  validation

  data

  data types

 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.

  field monitoring table

  database engine

  duplication check

  record format

 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

  School course

  Integer type database

  stocks and shares account

  Student laptop computer purchase

 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

  serial, binary and sentient

  sentient only

  binary, sentient and final

  sequential and indexed sequential

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

  record

  database

  file

  field

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

  record

  field

  file

  database

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

  field

  record

  database

  file

 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.

  integrities

  files

  database entities

  relationships