How is the database organised in oracle, Database Management System

Assignment Help:

How is the database organised in Oracle?

Database organized within Oracle in terms of table and table holds attributes and values.

A database consists of one or more logical units known as table spaces. Each table space within turn, consists of one or more physical structures known as data files. These might be either, files managed through the operating system or raw devices.

Oracle database consists of subsequent table spaces.

(i) System (ii) Table spaces to store user data (iii) Temporary table spaces.

The space in table space is separated into units, called segments, that each contains data for a specific data structure. These are four kinds of segments:

(i) Data segments
(ii) Index segments
(iii) Temporary segments
(iv) Rollback segments

 


Related Discussions:- How is the database organised in oracle

Create a customer database and apply queries, For the question given below,...

For the question given below, you are required to submit design and implementation documentation as described over the page. Design, implement (in Java), test and document a set of

Answer, what is database management system? & why it is required?

what is database management system? & why it is required?

Relationship, what is the relationship between receipt and owner entities i...

what is the relationship between receipt and owner entities in computer sales and service company

Give the reasons for allowing concurrency, Give the reasons for allowing co...

Give the reasons for allowing concurrency? The reasons for allowing concurrency is if the transactions run serially, a short transaction might have to wait for a preceding long

Explain the fundamental concepts of object-orientation, Explain the Fundame...

Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.

Access data using logical database, If one requires to access data using...

If one requires to access data using Logical Database , the use of events is unavoidable. Yes, if someone wants to access data using Logical database then the use of events

Query, Use a Set operator to create a list of academics who have written or...

Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.

Explain concurrency problems, Question: a) There are three concurrency...

Question: a) There are three concurrency problems, i.e. three types of potential mistake which could occur if concurrency control is not properly enforced in the database syst

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