Exam 12: Database Administration and Security

When introducing a database into an organization, a(n) ____ impact is likely because the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions.

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

Procedures and standards must be revised at least ____ to keep them up-to-date.

____ security breaches include database access by computer viruses and by hackers whose actions are designed to destroy or alter data.

A(n) ____ plan is a set of instructions generated at application compilation time that predetermines how the application will access the database at run time.

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

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

The most common backup medium has traditionally been ____________________.

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

The DBA must periodically generate a(n) ____________________ report to determine whether there have been actual or attempted security violations-and, if so, from what locations, and if possible, by whom.

____ are general statements of direction or action that communicate and support DBA goals.

System support activities cover all tasks directly related to the day-to-day operations of a DBMS and its applications.

Describe the DBA's managerial role.

The DBA's function includes educating the ____________________ in the services provided and how those services enhance data stewardship and data security.

The maintenance activities of the DBA are an extension of the operational activities.

____ management is designed to limit access to the database.

____________________ decisions are short term and affect only daily operations; for example, deciding to change the price of a product to clear it from inventory.

____________________ focuses on maintaining the data free of inconsistencies and anomalies.

An access ____________________ describes the type of authorized access.

The allocation of storage resources is determined when the DBMS is created.