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 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) policy
B) rule
C) procedure
D) standard

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

The storage locations for multiple backups must include sites inside and outside the organization.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

The DBA must review the database application design to ensure that transactions are ,meaning that they mirror real-world events.

"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.

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 administration,standards are written instructions that describe a series of steps to be followed during the performance of a given activity.

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

_____ deals with ensuring that data is protected against unauthorized access,and if the data are accessed by an authorized user,that the data are used only for an authorized purpose.

The aspect of introducing a DBMS in an organization deals with hardware and software changes in the organization.

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

The introduction of a DBMS represents a big change and challenge,and is likely to have a profound impact throughout the organization.

User-access management is a subset of .

Protecting the security and integrity of a database is a function of authorization management.

In case a company installs several incompatible databases and assigns a DBA for each of them,the general coordinator of all such DBAs is known as the administrator.

In the context of data quality management tools,software is one that gathers statistics,analyzes existing data sources and metadata to determine patterns,and compares the patterns against standards that the organization has defined.

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

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

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