Exam 15: Database Administration and Security

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

Placing the DBA function in a(n)____________________ position often creates a consulting environment in which the DBA is able to devise the data administration strategy but does not have the authority to enforce it or to resolve possible conflicts.

The DBA works with managers to ensure the quality and integrity of database design and transactions.

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

The end user's role requires a broad understanding of DBMS functions,configuration,programming languages,data modeling and design methodologies,and so on.

The DBA must periodically generate a(n)____________________ report to determine whether there have been actual or attempted security violations-and,if so,from what locations,and if possible,by whom.

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

The selection of the DBMS ____________________ involves asking the question,"Are the company's needs better served by a relational,object-oriented,or object/relational DBMS?"

Describe the need for convenient and safe backup storage.

User-access management is a subset of ____.

The DBA interacts with the end user by providing data and information support services to the organization's departments.

Protecting the data in the database is a function of authorization management.

The DBA must supervise the installation of all software and hardware designated to support the data administration strategy,must have a thorough understanding of the components being installed,and must be familiar with the installation,configuration,and startup procedures of such components.

Incremental backups produce a backup of all data.

The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.

The DBA must define data views to protect and control the scope of the data that are accessible to an authorized user.

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

A DBMS facilitates ____.

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

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