FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 15: Database Administration and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

At the level of middle management, the database must be able to .

A) provide a framework for defining and enforcing organizational policies
B) provide the data necessary for tactical decisions and planning
C) provide feedback to monitor whether a company is achieving its goals
D) provide access to external and internal data to identify growth opportunities

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

CASE tools provide support for the coding and implementation phases.

A) Front-end
B) Back-end
C) Vertical
D) Horizontal

E) A) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

A security breach is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.

The component of a CASE tool produces the information system's input/output formats.

A(n) data dictionary is automatically updated by the DBMS with every database access.

are written instructions that describe a series of steps to be followed during the performance of a given activity.

User-access management is a subset of .

The person responsible for the control of the centralized and shared database is the database .

In the context of an organization's managerial structure, decisions are short term and affect only daily operations; for example, deciding to change the price of a product to clear it from inventory.

In the context of developing a data administration strategy, a(n) provides a framework that includes computerized, automated, and integrated tools such as a DBMS and CASE tools.

In the context of database security measures, enforcing complex password policies will address the security vulnerabilities of the operating system component.

The DBA interacts with the end user by providing data and information support services to the organization's departments.

The administrator is responsible for strategic planning.

Disaster management includes all the end-user activities designed to secure data availability before a physical disaster or a database integrity failure.

In case a company installs several incompatible databases and assigns a DBA for each of them, the general coordinator of all such DBAs is known as the administrator.

allows for the translation of the company's strategic goals into the data and applications that will help the company achieve those goals.

Incremental backups produce a backup of all data.

When performing user access management, a DBA defines each user to the database at the levels.

The introduction of a DBMS represents a big change and challenge, and is likely to have a profound impact throughout the organization.

In the context of data quality management tools, software is one that gathers statistics, analyzes existing data sources and metadata to determine patterns, and compares the patterns against standards that the organization has defined.