Exam 15: Database Administration and Security

An organization is subject to a(n)_________________________ cycle;that is,the data user applies intelligence to data to produce information that is the basis of knowledge used in decision making by the user.

Most of today's successful organizations depend on the ____________________ database to provide support for all of their operations-from design to implementation,from sales to services,and from daily decision making to strategic planning.

A full backup,or database dump,produces a complete copy of the entire database.

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

One of the important functions provided by the database ____ is to reserve the resources that must be used by the database at run time.

The advent of the DBMS and its shared view of data produced a new level of data management sophistication and led the DP department to evolve into a(n)_________________________ department.

A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.

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.

The storage locations for multiple backups must include sites inside and outside the organization.

In the IBM DB2 system catalog tables,____________________ stores one row for each column of each table or view.

The DBA's ____ role is focused on personnel management and on interactions with the end-user community.

The most common backup medium has traditionally been ____________________.

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

A(n)____ data dictionary is not updated automatically and usually requires a batch process to be run.

In large organizations,the DSO's activities are often classified as ____________________ management.

Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.

____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.

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

The DBA must review the database application design to ensure that transactions are ____________________,meaning that they do not overload the DBMS.

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