10

7. Informing potential users of what data already exists in the database would be most directly characterized as ____. a. DBMS performance monitoring b. arbitration of disputes and usage authorization c. documentation and publicity d. data standards e. data planning

c

10. All of the following are responsibilities of database administration, except ____. a. DBMS data and software maintenance b. DBMS performance monitoring c. Data dictionary operations d. Data planning e. DBMS troubleshooting

d

15. The most appropriate tool for accurately supporting the relational query optimizer is the ____. a. active data dictionary b. operational database c. data repository d. data catalog e. passive data dictionary

d

18. All of the following are characteristics of relational DBMS catalogs, except ____. a. they are highly active b. their main purpose is to accurately support the relational query optimizer c. they are themselves relational databases d. they include the full range of data dictionary entities e. they try to find an efficient access path to satisfy a query

d

2. Database administration is mainly ____ function. a. a programming b. a planning and analysis c. a hardware maintenance d. an operational, day-to-day monitoring and management e. a finance and accounting

d

11. Handling a DBMS application failure during execution would be most directly characterized as ____. a. DBMS data and software maintenance b. DBMS performance monitoring c. Data dictionary operations d. Data planning e. DBMS troubleshooting

e

16. All of the following are likely data dictionary entities in the relational database environment, except ____. a. tables b. disks c. queries d. application programs e. operational data

e

5. Managing Enterprise Resource Planning (ERP) databases would be most directly characterized as ____. a. modularized, efficient programming b. data as a shared corporate resource c. efficiency in job specialization d. operational management of data e. managing externally acquired databases

e

8. All of the following are responsibilities of data administration, except ____. a. liaison to systems analysts and programmers b. data coordination c. training d. promoting data's competitive advantage e. DBMS usage and security monitoring

e

12. Installing new versions of the DBMS and installing "fixes" or "patches" (corrections) to the DBMS would be most directly characterized as ____. a. DBMS data and software maintenance b. DBMS performance monitoring c. Data dictionary operations d. Data planning e. DBMS troubleshooting

a

3. All of the following are advantages of data and database administration, except ____. a. modularized, efficient programming b. data as a shared corporate resource c. efficiency in job specialization d. operational management of data e. managing externally acquired databases

a

6. All of the following are responsibilities of data administration, except ____. a. DBMS performance monitoring b. arbitration of disputes and usage authorization c. documentation and publicity d. data standards e. data planning

a

1. Data administration is mainly ____ function. a. a programming b. a planning and analysis c. a hardware maintenance d. an operational, day-to-day monitoring and management e. a finance and accounting

b

14. All of the following are realizations of the metadata concept, except ____. a. active data dictionary b. operational database c. data repository d. data catalog e. passive data dictionary

b

9. Maintaining a reasonable amount of control over centralized/decentralized data would be most directly characterized as ____. a. liaison to systems analysts and programmers b. data coordination c. training d. promoting data's competitive advantage e. DBMS usage and security monitoring

b

13. The term that describes data about data is ____.

c

17. The pair of dictionary entities that are in the "impact of change" relationship are ____. a. tables and attributes b. people and databases c. programs and tables d. tables and disks e. Web pages and jobs

c

4. Having dedicated experts whose job it is to perform database design would be most directly characterized as ____. a. modularized, efficient programming b. data as a shared corporate resource c. efficiency in job specialization d. operational management of data

c