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 51

Short Answer

Review LaterAdd Note

Review Later

The advent of the DBMS and its shared view of data produced a new level of data management sophistication and led the DP department to evolve into a(n)_________________________ department.

Correct Answer

verified

informatio...

View Answer

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

The end user must provide testing and evaluation services for all the database and DBA applications.

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

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

An organization is subject to a(n)_________________________ cycle; that is,the data user applies intelligence to data to produce information that is the basis of knowledge used in decision making by the user.

____________________ focuses on maintaining the data free of inconsistencies and anomalies.

Most of today's successful organizations depend on the ____________________ database to provide support for all of their operations-from design to implementation,from sales to services,and from daily decision making to strategic planning.

The most common backup medium has traditionally been ____________________.

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

When introducing a database into an organization,a(n) ____ impact is likely because the database approach creates a more controlled and structured information flow and thus affects people,functions,and interactions.

A ____ is a named collection of settings that control how much of the database resource a given user can use.

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

A(n) ____ data dictionary is automatically updated by the DBMS with every database access.

____________________ decisions are short term and affect only daily operations; for example,deciding to change the price of a product to clear it from inventory.

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

The DBA's ____ role covers activities involving the use of the DBMS.

Procedures and standards must be revised at least ____ to keep them up-to-date.

Performance monitoring and ____________________ require much of the DBA's attention and time.These activities are designed to ensure that the DBMS,utilities,and applications maintain satisfactory performance levels.

Classifying users into ____ according to common access needs facilitates the DBA's job of controlling and managing the access privileges of individual users.

Instructions to create a password are an example of a ____.

The DBMS must provide tools that give each level of management a different view of the data and support the required level of decision-making.