Preview

01 - Introduction to Databases

 1. What is a Database?

  A database is the same thing as a website. It stores web pages

  A database is an internet service provider

  A database is an internet based search engine. It can only perform a search

  A database is a computerised system that makes it easy to search, select and store information

 2. A school or university might use a database to:

  store student's marks and grades

  store as well as track student's progress and attendance

  All of the options listed here are valid answers

  store information about students e.g. name, gender.

 3. There are two types of databases. The __________ database has just a single table.

  flatfile

  matrix

  benchfile

  relational

 4. A database for a small book store would be made up of a single ____________ with columns and rows.

  report

  primary key

  table

  query

 5. Each item (or row) you put into your database (such as a row about a book) would be called a:

  files

  columns

  record

  rows

 6. The _________ of the table are called fields. A book store might have fields for ISBN, title, author etc.

  rows

  files

  columns

  records

 7. A database is a collection of data or information which is held together in an organised or logical way.
This is an alternative definition of a database

  TRUE

  FALSE

 8. Tables can store many records - from a few to millions for a large company database.

  TRUE

  FALSE

 9. An example of a piece of software that allows you to create a database is:

  Microsoft Publisher

  Microsoft Power Point

  Adobe Animator

  Microsoft Access

 10. A database like Microsoft Access allows for the creation of tables, queries and reports.

  FALSE

  TRUE