Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

What are the basic elements of Base configuration of an
oracle Database ?

Question Posted / guest


What are the basic elements of Base configuration of an oracle Database ?..

Answer / guest

It consists of
one or more data files.
one or more control files.
two or more redo log files.
The Database contains
multiple users/schemas
one or more rollback segments
one or more tablespaces
Data dictionary tables
User objects (table,indexes,views etc.,)
The server that access the database consists of
SGA (Database buffer, Dictionary Cache Buffers,
Redo log buffers, Shared SQL pool)
SMON (System MONito)
PMON (Process MONitor)
LGWR (LoG Write)
DBWR (Data Base Write)
ARCH (ARCHiver)
CKPT (Check Point)
RECO
Dispatcher
User Process with associated PGS

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

What are the different Sequence of events takes place while starting a Database ?

1 Answers   KPSC Karnataka Public Service Corporation,

what is "TABLE" datatype ?

2 Answers  

How does distributed database work?

0 Answers  

What is data independence and also explain its types?

0 Answers  

What is rdbms with diagram?

0 Answers  

What is data management process?

0 Answers  

What are the different types of database?

0 Answers  

All questions related to Control m monitoring tool

0 Answers   HCL, TY,

What is a 3nf table?

0 Answers  

What is the data in a database?

0 Answers  

Where the data file for system Tablespace is located? What is its name, initial size and maxsize?

1 Answers  

is it sufficient to normalize a database up to 3NF?

4 Answers  

For more Database Management Interview Questions Click Here
Categories