Quiz 1 (Past tests)

Question 1

T/F: the insulation between data and programs allows the DBMS software to work with different database applications.

Answer 1

false, the self-describing nature of a database system is what allows…

Question 2

________ is concerned with the rearrangement and possible reordering of operations, eliminations of redundancies, and use of efficient search algorithms during execution.

Answer 2

query optimizer

Question 3

T/F: A data dictionary utility is similar to the system catalog, but the system catalog includes a wider variety of information ad is accessed mainly by users and DBMS software.

Answer 3

false

Question 4

T/F: embedding the structure of data files in the application programs is considered an advantage of using the database approach.

Answer 4

false

Question 5

the DBMS may be unnecessary when access to data by multiple users is ___________.

Answer 5

not required