Grade 11 Theory IV — Database Management & Design

Question 1

What does DBMS stand for?

Question 2

Which of these is an example of database management software?

Question 3

Which of these is an example of an OPEN SOURCE database management system?

Question 4

The person specifically responsible for managing and maintaining an organisation's database systems is called the:

Question 5

A database distributed and replicated across many servers worldwide, as used by very large organisations, is an example of a:

Question 6

In a database table, a single row of related data (e.g. one learner's details) is called a:

Question 7

In a database table, a single column, holding one specific piece of information for every record (e.g. Surname), is called a:

Question 8

A field that uniquely identifies each record in a table, with no two records ever sharing the same value, is called the:

Question 9

Checking that a captured value falls within an acceptable minimum and maximum (e.g. an age between 0 and 120) is a form of:

Question 10

Checking that a captured value matches an expected pattern (e.g. an ID number's exact number of digits) is a form of:

Question 11

Which of these is a characteristic of QUALITY data, as opposed to poor-quality data?

Question 12

Which database maintenance task specifically means changing the value of an existing record's field?

Question 13

Which database maintenance task means generating information FROM the data already stored, e.g. finding all learners above a certain mark?

Question 14

A situation where the same piece of data is unnecessarily stored in more than one place in a database is called:

Question 15

An unexpected or inconsistent result caused by poor database design, e.g. losing information when a single record is deleted, is called an:

Question 16

The process of restructuring a database to reduce data redundancy and eliminate anomalies is called:

Question 17

A field in one table that refers to the primary key of another table, used to create a relationship between them, is called a:

Question 18

A relationship where one class register can be linked to many pupils, but each pupil belongs to only one register, is an example of what type of relationship?

Question 19 — Match the columns

Match each database term in Column A to its definition in Column B.

Question 20 — Match the columns

Match each database quality characteristic in Column A to what it protects against in Column B.