Exam 15: Database Administration and Security

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

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

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.

The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.

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

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.

Coordinating, monitoring, and allocating database administration resources is included in a DBA's role.

Performance monitoring and activities are designed to ensure that the DBMS, utilities, and applications maintain satisfactory performance levels.

When performing user access management, a DBA assigns passwords to each user at both the operating system and DBMS levels.

The requirement that a password must have a maximum of 12 characters is an example of a(n) .

In the context of database usage monitoring, a(n) is a file that automatically records a brief description of the database operations performed by all users.

The DBA function provides data modeling and design services to the end-user community, often through coordination with an application development group within the data-processing department.

An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations.

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

A(n) plan is a set of instructions generated at application compilation time that predetermines how the application will connect to and communicate with the database at run time.

In the context of the Oracle Enterprise Manager, a is a named collection of settings that control how much of the database resource a given user can use.

The role of a DBA covers activities that involve evaluating, selecting, installing, and maintaining a DBMS and its related utilities and applications.

Testing procedures and standards must already be in place before any application program can be approved for use in the company.

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

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