A.3 Further aspects of database management

Question 1

Database Administrator

Answer 1

Responsible for accurately and securely using, maintaining and developing computerized databases

Question 2

Methods of database recovery

Answer 2

1. Rollback
2. Rollforward

Question 3

Rollback

Answer 3

DBMS uses log to undo any changes made to database in a period of time

Question 4

Rollforward

Answer 4

DBMS uses log to re-enter changes made to database since last save or back up

Question 5

How integrated database systems function

Answer 5

Organized logically as a set of relations. The attributes of relations can assume the data type “picture”

Question 6

Use of databases in areas such as stock control, police records, health records, employee data

Answer 6

Used to store and access records that any of the fields have
Databases would be one of the few storage methods that could be used in order to store all the different records.

Question 7

Methods to ensure the privacy of the personal data

Answer 7

Personal data management act or privacy

Question 8

Personal data management act or privacy

Answer 8

Ensures that data can be shared/ edited/ viewed only by authorized people.

Question 9

Data mining

Answer 9

Process of finding trends inside of one data warehouse

Question 10

Data matching

Answer 10

Process of finding trends across multiple data warehouses.