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 21

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) B) and D)
F) C) and D)

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) user groups
B) sections
C) authorization schemes
D) policy definitions

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

A DBMS facilitates ____.

Incremental backups produce a backup of all data.

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

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

The end user's role requires a broad understanding of DBMS functions,configuration,programming languages,data modeling and design methodologies,and so on.

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

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

The selection of the DBMS ____________________ involves asking the question,"Are the company's needs better served by a relational,object-oriented,or object/relational DBMS?"

Describe the need for convenient and safe backup storage.

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

Protecting the data in the database is a function of authorization management.

Placing the DBA function in a(n)____________________ position often creates a consulting environment in which the DBA is able to devise the data administration strategy but does not have the authority to enforce it or to resolve possible conflicts.

The DBA must supervise the installation of all software and hardware designated to support the data administration strategy,must have a thorough understanding of the components being installed,and must be familiar with the installation,configuration,and startup procedures of such components.

User-access management is a subset of ____.

The DBA must define data views to protect and control the scope of the data that are accessible to an authorized user.

The DBA must periodically generate a(n)____________________ report to determine whether there have been actual or attempted security violations-and,if so,from what locations,and if possible,by whom.

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

The DBA works with managers to ensure the quality and integrity of database design and transactions.