Preview

04 - Database definitions (keys)

 1. A database is being created on Crime in a local area. Examples of _______ could be 'Crimes', 'Victims', 'Criminals' and 'Police Officers'

  relationships

  files

  fields

  tables

 2. What type of database might store tables like 'People', 'Relationships', 'Messages','Pictures'?

  Social Networking site

  A football league

  A local library

  None of the above

 3. An essential feature of a database is making each record unique. To make them unique we we use ______________

  composite key

  primary keys

  attributes

  foreign keys

 4. Referential integrity is the process of ensuring ____________ as it makes sure that information is not removed if it is required elsewhere in a linked database.

  encryption

  consistency

  speed

  uniqueness

 5. An item of data that can be used to index the whole data set (can't be primary key, eg sort by date)

  three database views

  foreign key

  composite key

  secondary key

 6. Internal, conceptual and end user

  three database views

  foreign key

  composite key

  secondary key

 7. Combines two fields to make a primary key

  composite key

  foreign key

  three database views

  secondary key

 8. The term attribute refers to a ___________ of a table.

  file

  primary key

  column

  data type

 9. Which of the following gives a logical structure of the database graphically?

  Flow chart

  Entity relationship diagram

  End diagram

  Database diagram

 10. If you were collecting and storing information about your music collection, an album would be considered a(n) _____.

  fields

  folder

  entity

  files


Report an error