In a typical installation, what are the key responsibilities of a database administrator (DBA).
CS Professional · Information Technology and Systems Audit · PYQS · December 2016
In a typical installation, what are the key responsibilities of a database administrator (DBA).
Answer & Explanation:
In a typical installation, major responsibilities of a Database Administrator (DBA) are given as follows: Providing the standards and the administration of databases and their use; Database tuning and performance monitoring; Application tuning and performance monitoring; Plan growth and changes (capacity planning); Guiding, reviewing, and approving the design of a new databases; Determining the rules of access to the data and monitoring its security; Ensuring database integrity and availability, and monitoring the necessary activities for reorganization backup and recovery; and Approving the operation of new programs with existing production databases, based on results of testing with test data.
Topics: Database Management Systems
Related Questions in this Topic
- Discuss about RDBMS and Object oriented DBMS with examples.
- Distinguish between the following: Hierarchical and network DBMS
- Write short notes on the following: Distributed Database
- Describe the various types of files that can be created in SQL Server databases.
- In spite of the advantages of using a Database Management System (DBMS), there are a few situations or circumstances in ...