Describe the responsibilities of the dba and the database, Database Management System

Assignment Help:

Describe the responsibilities of the DBA and the database designer ?

The responsibilities of DBA and database designer are:
1. Planning for the database's future storage needs
2. Describing database availability and fault management architecture
3. Defining and forming environments for development and latest release installation
4. Creating physical database storage structures after developers have designed an application
5. Constructing the database
6. Determining and setting the physical and size locations of data files
7. Evaluating latest hardware and software purchase
8. Researching, testing, and recommending tools for Oracle development, database administration, modeling, and backup and recovery implementation, as well as planning for the future
9. Giving database design and implementation
10.Understanding and employing the optimal flexible architecture to ease administration, permit flexibility within managing I/O, and to increase the capability to scale the system


Related Discussions:- Describe the responsibilities of the dba and the database

Sql, Events4Fun is an event management company in Europe with branches in S...

Events4Fun is an event management company in Europe with branches in South America as well. The company is well-known for its efficiency, good-quality services, and affordable char

Datamodels, explain thee diffrent types of data models

explain thee diffrent types of data models

Define the query optimisation, Define the Query optimisation The query ...

Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica

Which operations need the participating relations to union, Which operation...

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

What is the used of specifying alias, What is the used of specifying alias?...

What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.

Database design, Build a database application for a sports league. Assume y...

Build a database application for a sports league. Assume your application is to keep track of teams and equipment that is checked out to teams. Explain the steps that is needed and

Benefits of views-data control, Benefits: It limits data access. ...

Benefits: It limits data access. It makes difficult queries look easy. It permits data independence. It presents dissimilar views of the similar data.

Write a short note on built in function in qbe, Write a short note on built...

Write a short note on built in function in QBE? Built in function in QBE: QBE involves various built in functions like AVG, MAX,MIN,SUM and CNT. We must prefix these operator

Create a new service-based database, In this assignment, you will create a ...

In this assignment, you will create a program that works with multiple tables. In this assignment, you will work with the factory and sales tables. 1. Create a new project nam

Cataloguing, differences between a classified catalog and a dictionary cata...

differences between a classified catalog and a dictionary catalog

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