Exam 15: Database Administration and Security

The DBA's ____ role is focused on personnel management and on interactions with the end-user community.

The DBA must review the database application design to ensure that transactions are ____________________,meaning that they do not overload the DBMS.

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

Physical protection of hardware and software must be accomplished by the use of open installations with restricted area access.

One of the important functions provided by the database ____ is to reserve the resources that must be used by the database at run time.

Current data distribution philosophy makes it easy for ____ end users to access the database.

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

A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.

The DBA's function includes educating the ____________________ in the services provided and how those services enhance data stewardship and data security.

Training people to use the DBMS and its tools is not included in the DBA's technical activities.

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

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.

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

A(n)____ is a logical storage space in Oracle.

____ are written instructions that describe a series of steps to be followed during the performance of a given activity.

____ allows for the translation of the company's strategic goals into the data and applications that will help the company achieve those goals.

A DBMS facilitates ____.

The person responsible for the control of the centralized and shared database is the database ____.

____ CASE tools provide support for the planning,analysis,and design phases.

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.