Answer Posted / su
-Oracle is a database, you can store data(RDBMS, since it
follows more than 8 rule out of 12 proposed by E F Codd).
-Made up of memory structures and back ground processes.
-Memory structure - SGA (system global area) and PGA
(Process Global Area)
-Background Process are Database writer (DBWR) which
actually writes to the physical files (Data files), Log
Writer (LGWR) which writes to the physical log files
(important to get the database in consistent state if there
is a crash)
-Combination of memory structure and backgroung processes
gives us oracle instances , which is instrumental in
helping us work with the oracle database
:)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
difference of using cursor for loop and open,fetch,close.which one is better
What is chargeback invoice? How do we create it? : oracle accounts receivable
Explain about party and customer in ar : oracle accounts receivable
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
can u give guidance abt packages of plsql
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
How many segment are present in Oracle Manufacturing
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
how to replace not in with not exist?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?