YEAR 11 DP EXAM REVIEW

1. Special lookup table used to speed up data retrieval is called

• search key

• indexes

• log

• pointer

2. A unique key used to identify each row on a table is referred to as

• A. Composite key

• B. Primary key

• C. Secondary key

• D. Compound key

3. How many clustered indexes are allowed in a table?

• A. one

• B. two

• C. three

• D. four

4. They are the rules enforced on the data columns of a table.

• A. Relational

• B. Megabyte

• C. Constraints

• D. Indexes

5. Modifying the database structure is the role of

• A. DBA

• B. ABA

• C. ADA

• D. ABA

6. To scramble data means to

• A. View data

• B. Encrypt data

• C. Password data

• D. Manipulate data

7. The process of changing the encrypted data to its original form is called

• A. Decryption

• B. Encryption

• C. Encoding

• D. Decording

8. Protecting database and the various applications that access it is a part of

• A. Database Administrator

• B. Database

• C. Validation

• D. Database security

9. The copying and archiving of data to restore the original after a data loss event is

• A. Integrity control

• B. Backups

• C. Rollback

• D. Redo

10. The secondary purpose of backups is to

• A. Delete data

• B. Copy data

• C. Recover data

• D. Edit data