+1 vote
143 views
in Database Management Systems by

1 Answer

+1 vote
by
selected by (user.guest)
 
Best answer

Database Administrator

One of the main reasons for using DBMSs is to have central control of both the data and the programs that access those data. A person who has such central control over the system is called a database administrator (DBA). The functions of a DBA include:  

Schema definition. The DBA creates the original database schema by executing a set of data definition statements in the DDL.  

Storage structure and access-method definition. Schema and physical-organization modification. The DBA carries out changes to the schema and physical organization to reflect the changing needs of the organization, or to alter the physical organization to improve performance.  

Granting of authorization for data access. By granting different types of authorization, the database administrator can regulate which parts of the database various users can access. The authorization information is kept in a special system structure that the database system consults whenever someone attempts to access the data in the system. Routine maintenance. Examples of the database administrator’s routine maintenance activities are:  

Periodically backing up the database, either onto tapes or onto remote servers, to prevent loss of data in case of disasters such as flooding.  

Ensuring that enough free disk space is available for normal operations, and upgrading disk space as required.  

Monitoring jobs running on the database and ensuring that performance is not degraded by very expensive tasks submitted by some users.

Related questions

+2 votes
1 answer 754 views
+1 vote
1 answer 68 views
+2 votes
1 answer 378 views
+1 vote
1 answer 29 views
+1 vote
1 answer 39 views
0 votes
1 answer 61 views
0 votes
1 answer 71 views
0 votes
1 answer 77 views
asked Sep 23 in Database Management Systems by (user.guest)
+1 vote
1 answer 113 views
+1 vote
1 answer 138 views
0 votes
0 answers 114 views
+1 vote
1 answer 150 views
+1 vote
1 answer 178 views
+2 votes
1 answer 408 views
+2 votes
1 answer 502 views
+1 vote
1 answer 3.3k views
+2 votes
1 answer 913 views
+1 vote
1 answer 1.3k views
+1 vote
1 answer 490 views
+1 vote
1 answer 498 views
+2 votes
1 answer 286 views
+2 votes
1 answer 478 views
+1 vote
1 answer 190 views
+1 vote
1 answer 109 views
+1 vote
1 answer 86 views
asked Sep 28 in Others by anonymous
+1 vote
1 answer 105 views
asked Sep 22 in Others by anonymous
+1 vote
1 answer 39 views
+1 vote
1 answer 112 views
+1 vote
1 answer 67 views
+1 vote
1 answer 1.6k views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...