Modern Database Management 11th Edition By Hoffer – Test Bank

Chapter 11   Data and Database Administration

1) Which of the following is true of poor data and/or database administration?

1. A) Data timing problems
2. B) Multiple entity definitions
3. C) Unknown meanings of stored data
4. D) All of the above

Answer:  D

Diff: 2    Page Ref: 464

Topic:  Introduction

AACSB:  Use of Information Technology

2) ________ is a technical function responsible for database design, security, and disaster recovery.

1. A) Data administration
2. B) Database administration
3. C) Tech support
4. D) Operations

Answer:  B

Diff: 1    Page Ref: 466

Topic:  Introduction

AACSB:  Use of Information Technology

3) An information repository supplies information to:

1. A) users.
2. B) automated CASE tools.
3. C) database management systems.
4. D) all of the above.

Answer:  D

Diff: 2    Page Ref: 466

Topic:  The Roles of Data and Database Administrators

AACSB:  Use of Information Technology

Subtopic:  Traditional Database Administration

4) Which of the following functions do cost/benefit models?

1. A) Database planning
2. B) Database analysis
3. C) Database design
4. D) Operations

Answer:  A

Diff: 2    Page Ref: 468

Topic:  The Roles of Data and Database Administrators

AACSB:  Use of Information Technology

Subtopic:  Evolving Approaches to Data Administration

5) Which of the following functions develop integrity controls?

1. A) Database planning
2. B) Database analysis
3. C) Database implementation
4. D) Database design

Answer:  D

Diff: 2    Page Ref: 468

Topic:  The Roles of Data and Database Administrators

AACSB:  Use of Information Technology

Subtopic:  Evolving Approaches to Data Administration

6) Which of the following functions model business rules?

1. A) Database planning
2. B) Database analysis
3. C) Database design
4. D) Operations

Answer:  B

Diff: 2    Page Ref: 468

Topic:  The Roles of Data and Database Administrators

AACSB:  Use of Information Technology

Subtopic:  Evolving Approaches to Data Administration

7) A data warehouse administrator has which of the following responsibilities?

1. A) Build and administer an environment supportive of decision-support applications
2. B) Build a stable architecture for the data warehouse
3. C) Develop service level agreements with suppliers and consumers of data for the data warehouse
4. D) All of the above

Answer:  D

Diff: 1    Page Ref: 470

Topic:  The Roles of Data and Database Administrators

AACSB:  Use of Information Technology

Subtopic:  Data Warehouse Administration

8) An organization should have one data warehouse administrator for every:

1. A) 100 users.
2. B) 100 gigabytes of data in the enterprise data warehouse.
3. C) department.
4. D) processor.

Answer:  B

Diff: 2    Page Ref: 470

Topic:  The Roles of Data and Database Administrators

AACSB:  Analytic Skills, Use of Information Technology

Subtopic:  Data Warehouse Administration

9) An open-source DBMS is:

1. A) a free source-code RBMS that provides the functionality of an SQL-compliant DBMS.
2. B) a beta release of a commercial RDBMS.
3. C) an object-oriented database management system.
4. D) source code for a commercial RDBMS.

Answer:  A

Diff: 1    Page Ref: 471

Topic:  The Open-Source Movement and Database Management

AACSB:  Use of Information Technology

10) Which of the following threats involves outside parties using information to embarrass a company?

1. A) Accidental loss
2. B) Theft and fraud
3. C) Loss of confidentiality
4. D) Loss of data integrity

Answer:  C

Diff: 2    Page Ref: 473, 474

Topic:  Database Software Data Security Features

AACSB:  Use of Information Technology

Subtopic:  Threats to Data Security

11) Guidelines for server security should include all of the following EXCEPT:

1. A) securing the network between client and server.
2. B) guidelines for password lengths.
3. C) password naming conventions.
4. D) guidelines for frequency of password changes.

Answer:  A

Diff: 2    Page Ref: 475

Topic:  Establishing Client/Server Security

AACSB:  Use of Information Technology

Subtopic:  Server Security