Lesson 6.3: Database Management and Administration Tools Flashcards

1
Q

Database Administration

A

Database management and administration are important functions in any organization that is dependent on one or more databases. It refers to the whole set of activities that ensure all databases are highly available, secure, and scalable.

Scalability is the ability to accommodate increased demands while using existing resources (e.g., increasing memory capacity before being fully exhausted).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

DBA Responsibilities

A

A majority of the database administration (DBA) responsibilities fall into these categories:

Database security—ensuring that only authorized users have access to the database and fortifying it against unauthorized access

Database tuning—optimizing performance of database systems
High availability—making replicas (copies) of databases available
from various locations; if one copy is unavailable due to outage, the alternate location can continue database services

Business continuity—continuing core business operations effectively, even with the disruption of some auxiliary services

Backup and recovery—planning for and executing adequate backup and recovery procedures

Reporting—writing complex queries and generating reports for users
Designing and developing database applications—writing code to interact with the database resources

The DBA needs a complex set of specialized skills, as well as current knowledge of database developments, acquired through intense professional development.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly