FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATABASE ADMINISTRATION AND SECURITY

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is a reason why a DBMS’s daily operations must be clearly documented?
A
Documentation of the daily operations help a company set its long-term goals.
B
Documentation of the daily operations help manage the manual data resources of a company.
C
Documentation of the daily operations help pinpoint causes and solutions of database problems.
D
Documentation of the daily operations help free the DBA from many lower-level technology-oriented tasks.
Explanation: 

Detailed explanation-1: -Which of the following is a reason why a DBMS’s daily operations must be clearly documented? Documentation of the daily operations help a company set its long-term goals.

Detailed explanation-2: -System support activities cover all tasks directly related to the day-to-day operations of a DBMS and its applications. Training people to use the DBMS and its tools is not included in the responsibilities of a DBA. The maintenance activities of the DBA are an extension of the operational activities.

Detailed explanation-3: -At the middle management level, the database must be able to:-Deliver data neccessary for tactical decision making and planning. rights of individuals and the organization to determine the “who, what, when, where, and how” of data usage. to provide a seamless flow of information throughout the company.

Detailed explanation-4: -The day-to-day activities that a DBA performs as outlined in ITIL® Service Operation include: Creating and maintaining database standards and policies. Supporting database design, creation, and testing activities. Managing the database availability and performance, including incident and problem management.

Detailed explanation-5: -Monitoring and optimizing the performance of the database. Planning for backup and recovery of database information. Maintaining archived data on tape. Backing up and restoring the database.

There is 1 question to complete.