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 physical device which stores structured data

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

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

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

  records

  information types

  data types

  field types

 3. Fields contain _______

  validation

  files

  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

  record format

  duplication check

  database engine

 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

  Integer type database

  stocks and shares account

  School course

 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

  sequential and indexed sequential

  sentient only

  binary, sentient and final

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

  record

  file

  database

  field

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

  file

  database

  field

  record

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

  field

  database

  file

  record

 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.

  database entities

  files

  integrities

  relationships