FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 16: Database Administration and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

_____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.

A) Guidelines
B) Standards
C) Procedures
D) Documentations

E) A) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

_____ CASE tools provide support for the coding and implementation phases.

A) Front-end
B) Back-end
C) Vertical
D) Horizontal

E) C) and D)
F) None of the above

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

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

The _____ administrator is responsible for strategic planning.

A(n) _____ data dictionary is not updated automatically and usually requires a batch process to be run.

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.

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

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 developing a data administration strategy, a(n) _____ provides a framework that includes computerized, automated, and integrated tools such as a DBMS and CASE tools.

Performance monitoring and _____ activities are designed to ensure that the DBMS, utilities, and applications maintain satisfactory performance levels.

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

A(n) _____ is a logical storage area in Oracle.

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

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

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

Which of the following is a reason why a DBMS's daily operations must be clearly documented?

In the context of Oracle Enterprise Manager, a(n) _____ isa uniquely identifiable object that allows a given person to log on to the database.

A data administrator is also known as a(n) _____.

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

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.