1- All of the following are benefits of the database approach except

A) data integration and sharing.

B) decentralized management of data.

C) minimal data redundancy.

D) cross-functional analysis and reporting.

2- The physical view of a database system refers to

A) how a user or programmer conceptually organizes and understands the data.

B) how the DBMS accesses data for a certain application program.

C) how and where the data are physically arranged and stored.

D) how master files store data values used by more than one application program.

3- What is the difference in logical view and physical view?

Answer: The logical view is how the user or programmer conceptually organizes and understands the data, such as data organized in a table. The physical view, on the other hand, refers to how and where the data are physically arranged and stored in the computer system.

4- The logical view of a database system refers to

A) how a user or programmer conceptually organizes and understands the data.

B) how the DBMS accesses data for a certain application program.

C) how and where the data are physically arranged and stored.

D) how master files store data values used by more than one application program.

5- What acts as an interface between the database and the various application programs?

A) data warehouse

B) database administrator

C) database system

D) database management system