Exam 15: Database Administration and Security

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

Security breaches can yield a database whose integrity is either preserved or corrupted.

The DBA's ____ role covers activities involving the use of the DBMS.

Performance monitoring and ____________________ require much of the DBA's attention and time.These activities are designed to ensure that the DBMS,utilities,and applications maintain satisfactory performance levels.

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

Classifying users into ____ according to common access needs facilitates the DBA's job of controlling and managing the access privileges of individual users.

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.

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

____ deals with ensuring that data is protected against unauthorized access,and if the data are accessed by an authorized user,that the data are used only for an authorized purpose.

The DBMS must provide tools that give each level of management a different view of the data and support the required level of decision-making.

A ____ is a named collection of settings that control how much of the database resource a given user can use.

The most common backup medium has traditionally been ____________________.

Concurrent backups take place while the user is working on the database.

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.

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

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 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.

The end user must provide testing and evaluation services for all the database and DBA applications.

Instructions to create a password are an example of a ____.

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