Exam 16: Database Administration and Security

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

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 DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.

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

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

In the context of an organization's managerial structure,decisions are short term and affect only daily operations; for example,deciding to change the price of a product to clear it from inventory.

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

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

_____ activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications.

Training people to use the DBMS and its tools is not included in the responsibilities of a DBA.

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

At the level of middle management,the database must be able to .

In the context of database administration,is the extent to which individuals and organizations have the right to determine the "who,what,when,where,and how" of data usage.

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

Within the data security framework,is concerned with keeping data consistent and free of errors or anomalies.

When performing user access management,a DBA defines each user to the database at the levels.

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 administrator is responsible for strategic planning.

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

The maintenance activities of the DBA are an extension of the operational activities.