Preview

01 - Introduction to Databases

 1. What is a Database?

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

  A database is an internet service provider

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

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

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

  All of the options listed here are valid answers

  store student's marks and grades

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

  store as well as track student's progress and attendance

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

  relational

  flatfile

  benchfile

  matrix

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

  report

  query

  primary key

  table

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

  columns

  rows

  files

  record

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

  files

  columns

  records

  rows

 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

  FALSE

  TRUE

 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 Power Point

  Adobe Animator

  Microsoft Access

  Microsoft Publisher

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

  FALSE

  TRUE