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

Why is group-clause used?

0 Answers  

Explain database partitioning and its importance.

0 Answers  

HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.

1 Answers  

What is meant by system analysis?

0 Answers  

What is index and also explain types of indexing in dbms?

0 Answers  

I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?

1 Answers   eBay, Google,

Can we store images in database?

0 Answers  

What are the five steps of data modeling?

0 Answers  

What is Database testing and What are ways of writing test cases for database testing?

0 Answers   Ittiam Systems,

How to know the Architecture of the Database

0 Answers   HCL,

What is a relation in dbms?

0 Answers  

Why do we need foreign key?

0 Answers  

For more Database Management Interview Questions Click Here
Categories