Exam 16: Database Administration and Security

In the context of database administration,standards are written instructions that describe a series of steps to be followed during the performance of a given activity.

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

User-access management is a subset of .

A(n)is a logical storage area in Oracle.

A password must have a minimum of five characters" is an example of a .

Protecting the security and integrity of a database is a function of authorization management.

The DBA is responsible for ensuring that the data are distributed to the right persons,at the right time,and in the right format.

The DBA must review the database application design to ensure that transactions are ,meaning that they mirror real-world events.

When introducing a database into an organization,the database approach creates a more controlled and structured information flow and thus affects people,functions,and interactions.This leads to a(n)impact of the new database system.

Explain conflict and problem resolution as part of the DBA's end­user support services.

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

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

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

Which of the following is a reason why a DBMS's daily operations must be clearly documented?

The DSO's activities are often classified as management,which includes all DBA activities designed to ensure data availability following a physical calamity or a database integrity failure.

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.

A passive data dictionary is one that is updated automatically with every database access to keep its access information up to date.

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.

"All users must have passwords" is an example of a .

The aspect of introducing a DBMS in an organization deals with hardware and software changes in the organization.