Lesson 9: Keeping the Database Up to Date

Question 1

Integrity

Answer 1

This is a quality of being honest. In database terms, when data is used, it is intact and unchanged. Accuracy and consistency are elements of data integrity.

Question 2

Accuracy

Answer 2

A quality of data that it must be correct. Accuracy is one of the elements of data integrity.

Question 3

Consistency

Answer 3

A quality of data that, when changes take place in the database, they follow defined rules. Consistency is one of the elements of data integrity.

Question 4

ALTER TABLE

Answer 4

A SQL statement used to add, delete, or modify columns or constraints on an existing table.

Question 5

UPDATE…SET

Answer 5

A SQL statement used to modify existing rows in a table

Question 6

DELETE

Answer 6

A SQL statement used to delete existing rows in a table.

Question 7

BETWEEN

Answer 7

An operator to select values within a given range. The begin and end values are included.

Question 8

IS NULL

Answer 8

A SQL condition that will test a column to see if it is NULL (empty).