11 the logical structure of a database is described by the a data dictionary b schem 4306120

11 the logical structure of a database is described by the a data dictionary b schem 4306120

11) The logical structure of a database is described by the

A) data dictionary.

B) schema.

C) database management system.

D) internal level.

12) 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.

13) 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.

14) 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.

15) Record layouts, definitions, addresses, and indexes will be stored at the ________ level schema.

A) external

B) conceptual

C) internal

D) meta

16) The ________ contains information about the structure of the database.

A) data definition language

B) data dictionary

C) data warehouse

D) database management system

17) Which of the following would not be found in a data dictionary entry for a data item?

A) records containing a specific data item

B) physical location of the data

C) source of the data item

D) field type

18) The data dictionary usually is maintained

A) automatically by the DBMS.

B) by the database administrator.

C) by the database programmers.

D) by top management.

19) Reports produced using the data dictionary could include all of the following except a list of

A) programs where a data item is used.

B) synonyms for the data items in a particular file.

C) outputs where a data element is used.

D) the schemas included in a database.

20) Which statement below concerning the database management system (DBMS) is false?

A) The DBMS automatically creates application software for users, based on data dictionary parameters.

B) The DBMS automatically maintains the data dictionary.

C) Users' requests for information are transmitted to the DBMS through application software.

D) The DBMS uses special languages to perform specific functions.

Looking for a similar assignment? Get help from our qualified experts!

Order Now

Related Posts