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

6- The combination of the database, the DBMS, and the application programs that access the database through the DBMS is referred to as the

A) data warehouse.

B) database administrator.

C) database system.

D) database management system.

7- The ________ handles the link between the way data are physically stored and each user's logical view of that data.

A) database management software (DBMS)

B) database manager

C) data warehouse

D) data dictionary

8- The logical structure of a database is described by the

A) data dictionary.

B) schema.

C) database management system.

D) context diagram.

9- The schema that provides an organization-wide view of the entire database is known as the

A) external-level schema.

B) internal-level schema.

C) conceptual-level schema.

D) logical view of the database.

10- A set of individual user views of the database is called the

A) conceptual-level schema.

B) internal-level schema.

C) external-level schema.

D) meta-schema.

11- A low-level view of the database that describes how the data are actually stored and accessed is the

A) conceptual-level schema.

B) subschema.

C) internal-level schema.

D) external-level schema.