Exam 16: Database Administration and Security

Backups must be clearly identified through detailed descriptions and date information,assuring that the correct backup is used to recover the database.

Describe the DBA's managerial role.

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

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

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

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.

In the context of developing a data administration strategy,a(n)provides a framework that includes computerized,automated,and integrated tools such as a DBMS and CASE tools.

A full backup,or database dump,produces a complete copy of the entire database.

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 advancements in DBMS technology,the use of data services can free the DBA from many lower-level technology-oriented tasks.

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

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

CASE tools provide support for the coding and implementation phases.

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.

Based on the type of decision-making support required,database users may be classified into: operational,tactical,or _____.

In the context of ensuring integrity of a database,a(n)transaction is one that does not overload the DBMS.

In the context of the Oracle Enterprise Manager,a(n)is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.

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 can overlap.

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

The use of cloud-based data services alters and expands the typical DBA's role in both technical and managerial dimensions.What is the DBA's role in this environment?