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

Describe models which define the operations on classes, Describe briefly mo...

Describe briefly models which define the operations on classes. The three models which are used to define operations on classes are as: Object Model = data dictionary + Obje

Create student db and execute insert query, Create Student DB and execute I...

Create Student DB and execute Insert query? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course

Microeconomic, anyone have a textbook solutions case fair, 8 edition of vo...

anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

Objectives-database recovery and security, Objectives Define the te...

Objectives Define the terms RECOVERY and INTEGRITY; Define Recovery Techniques; Explain Error and Error detection techniques, and Define types of Authorisation.

Dirty reads-problems of concurrent transactions, Dirty Reads: T10 reads a ...

Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts. T9 T10 Value of x old value = 200

C PROBLEMS, how to solve the C type problems?

how to solve the C type problems?

Coursework, ERD Diagram of Medical Recruitment Agency?

ERD Diagram of Medical Recruitment Agency?

Improved performance, Improved performance: As the data is located near the...

Improved performance: As the data is located near the site of its demand, and given the inherent parallelism because of multiple copies, speed of database access may be good for di

What is called block-level striping, What is called block-level striping? ...

What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers

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