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

:)

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers  

---

as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers   HCL,

---

Describe what redo logs are.

1 Answers  

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

0 Answers  

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

0 Answers  

---

---

Name three advisory statistics you can collect.

1 Answers  

---

what is semphore explian it?

0 Answers   IBM,

---

What is the Symbol use for Inner Join

1 Answers   Oracle, TCS,

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

0 Answers  

---

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---

What is the difference between oracle media recovery and crash recovery?

0 Answers  

---

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

4 Answers   Icon,

---