___ is the de facto query language and data access standard supported by the majority of DBMS vendors.

___ is the de facto query language and data access standard supported by the majority of DBMS vendors.

a. DBMS
b. Access Query Language
c. Structured Query Language
d. 4GL



Answer: c. Structured Query Language

____ deals with fixing the database after a failure such as a disk or power failure.

____ deals with fixing the database after a failure such as a disk or power failure.

a. Access control
b. Backup
c. Recovery
d. Security


Answer: c. Recovery

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ____.

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ____.

a. access control
b. query language
c. table generator
d. security system



Answer: b. query language

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ____.

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ____.

a. development
b. upgrades
c. enhancements
d. tuning


Answer: d. tuning

___ are the instructions and rules that govern the design and use of the database system.

___ are the instructions and rules that govern the design and use of the database system.

a. Procedures
b. Hardware
c. Software
d. Data


Answer: a. Procedures

Where does the DBMS store the definitions of data elements and their relationships?

Where does the DBMS store the definitions of data elements and their relationships?

a. data map
b. data file
c. index
d. data dictionary


Answer: d. data dictionary

__ are considered database architects.

__ are considered database architects.

a. Systems analysts and programmers
b. Database administrators
c. Systems administrators
d. Database designers


Answer: d. Database designers