FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 15: Database Administration and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) license
B) role
C) profile
D) constraint

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

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

Coordinating, monitoring, and allocating database administration resources is included in a DBA's role.

"A password must have a minimum of five characters" is an example of a .

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

"All users must have passwords" is an example of a .

When introducing a database into an organization, the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions. This leads to a(n) impact of the new database system.

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

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

The requirement that a password must have a maximum of 12 characters is an example of a(n) .

The DSO's activities are often classified as management, which includes all DBA activities designed to ensure data availability following a physical calamity or a database integrity failure.

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.

The role of a DBA covers activities that involve evaluating, selecting, installing, and maintaining a DBMS and its related utilities and applications.

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

A passive data dictionary is one that is updated automatically with every database access to keep its access information up to date.

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

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 DBA can use an audit log to automatically record a brief description of the database operations performed by the users.

are general statements of direction or action that communicate and support DBA goals.

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.