Databases DeMYSTiFieD, 2nd Edition, 2nd Edition

Final Exam

Choose the correct responses to each of the multiple-choice questions. Note that there may be more than one correct response to each question.

1. Examples of logical changes that can be safely made in a system that has a high degree of logical data independence are

A. Adding data items to existing database objects

B. Adding new database objects

C. Deleting database objects

D. Deleting data items from existing database objects

E. Moving a database object from one physical file to another

2. Examples of physical changes that can be safely made in a system that has a high degree of physical data independence are

A. Adding new user views

B. Adding new data files

C. Moving a file from one disk device to another

D. Splitting or combining ...