Exam 15: Database Administration and Security

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

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

A(n)____________________ physically stores the database's data.

Explain user requirements gathering as part of the DBA's end-user support services.

In today's Internet environment,the DBA must also work with ____________________ and network administrators to implement efficient and secure Web-to-database connectivity.

____________________ deals with the rights of individuals and the organization to determine the "who,what,when,where,and how" of data usage.

The ____________________,also known as the information resource manager (IRM),usually reports directly to top management and is given a higher degree of responsibility and authority than the DBA,although the two roles overlap some.

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

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

A ____ is a uniquely identifiable object that allows a given person to log on to the database.

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(n)____ is a logical storage space in Oracle.

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

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.

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

One CASE tool,____________________ Data Modeler by Computer Associates,produces fully documented ER diagrams that can be displayed at different abstraction levels.

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

An access ____________________ describes the type of authorized access.

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.

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