Database concepts

Question 1

A database table is a

Answer 1

Structured collection of related data.

Question 2

A row or record in a table contains

Answer 2

All the information relating to a single entity such as a person

Question 3

A column or field in a table holds

Answer 3

a single item of information-one of theseb for each record

Question 4

What’s an Index?

Answer 4

Something that speeds up a search in a database - by inserting the data in a sorted order. For example, if a table is indexed by surname, a new record for Mr Aardvark would be inserted right at the top of the index, making it easier to find. If data is indexed alphabetically, you know when to stop searching (e.g. searching for Jones and you reach Miss Kumar - you know there isn’t a Jones because you have gone past Js

Question 5

What makes a database quicker for a user to search through?

Answer 5

An index

Question 6

SQL stands for…?

Answer 6

Structured Query Language

Question 7

In SQL an asterisk means

Answer 7

Select all fields

Question 8

A query is

Answer 8

a way of searching for specific data in a database

Question 9

A flat file database is

Answer 9

data stored in a single table or file

Question 10

If you had a table containing Bill, Jane and Fred and a select statement that gave ORDER BY name DESC, what order would they appear in?

Answer 10

Jane, Fred, Bill