please explain about oracle



please explain about oracle ..

Answer / 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

More Oracle AllOther Interview Questions

When the procedures or packagess become invalidate

3 Answers   TCS,


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

0 Answers   HP,


How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,


Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers   Ion Exchange,


What is $FLEX$ and $PROFILES$?

2 Answers  






What is store procedure?and how do u take the values from database and run in scripts?

2 Answers   Polaris,


Can We Restore a Table that accidantly dropped.

8 Answers   TCS,


Give two examples of referential integrity constraints.

1 Answers  


Explain the process of recievables in oracle financials. : oracle accounts receivable

0 Answers  


What is the Symbol use for Inner Join

1 Answers   Oracle, TCS,


hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers  


Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)