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 41

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

_____ activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications.

A) Backup and recovery
B) System support
C) Performance monitoring and tuning
D) Security auditing and monitoring

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

Training people to use the DBMS and its tools is not included in the responsibilities of a DBA.

security breaches include database access by computer viruses and by hackers whose actions are designed to destroy or alter data.

At the level of middle management,the database must be able to .

The administrator is responsible for strategic planning.

The maintenance activities of the DBA are an extension of the operational activities.

When performing user access management,a DBA defines each user to the database at the levels.

In the context of an organization's managerial structure,decisions are short term and affect only daily operations; for example,deciding to change the price of a product to clear it from inventory.

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

The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.

Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.

A(n)_____ physically stores the database's data.

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

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

The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.

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.

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.

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