GeekInterview.com
Series: Subject: Topic:
Question: 189 of 250

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

 It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary tablesUser objects (table,indexes,views etc.,)The server that access the database consists ofSGA  (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)RECODispatcherUser Process with associated PGS
Asked by: Interview Candidate | Asked on: Sep 6th, 2004

This Question is not yet answered!

Related Open Questions

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.