Describe five main functions of a database administrator, Database Management System

Assignment Help:

Describe five main functions of a database administrator.

Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Generally, these include:

a) Recoverability - Creating and testing Backups

b) Integrity - Verifying or helping to verify data integrity 

c) Security - Defining and/or implementing access controls to the data 

d) Availability - Ensuring maximum uptime   

e) Performance - Ensuring maximum performance 

f) Development and testing support - Helping programmers and engineers to efficiently utilize the database.


Related Discussions:- Describe five main functions of a database administrator

Transactions and concurrency management, Transactions And Concurrency Manag...

Transactions And Concurrency Management  Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

4, explain the level architectures of the database management system

explain the level architectures of the database management system

What are referential integrity constraints, What are referential integrity ...

What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

Primary index, Primary index A primary index is a file that has a sorte...

Primary index A primary index is a file that has a sorted series of records having two columns: a block address for that key field in the data file; and the ordering key field.

Determine the method of choosing algorithms, Determine the method of Choosi...

Determine the method of Choosing Algorithms In general, most of operations are easy and have a satisfactory algorithm since description of what is to be done also shows how i

Er diagrams, in an organization several projects are undertaken. Each proje...

in an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the

Create table, What are the advantages of creating a table from existing tab...

What are the advantages of creating a table from existing table?

Explain the ansi -sparc schema architecture, (a) Differentiate between info...

(a) Differentiate between information and data . (b) List and briefly explain five potential benefits of the database approach compared to conventional file systems. (c) Diff

Eliminate redundant data, Eliminate Redundant Data In the "Database Rel...

Eliminate Redundant Data In the "Database Relation" above, the primary key is made up of the D-ID and the Emp-ID. The database-name relies only on the D-ID. The similar databas

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd