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  

---

Where would you look for errors from the database engine?

2 Answers   Fintellix,

---

statement string in open is null or 0 length ORA-40735

1 Answers   RoboSoft, Unilog,

---

how to display last 5 letters from a name (take emp table ename )

6 Answers   IBM,

---

What is the disk migration? what is the steps involved in oracle disk migration?

0 Answers  

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---

what is shared memory?

1 Answers   IBM,

---

Explain an ORA-01555

2 Answers  

---

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

0 Answers  

---

what is difference between inner join & nested query or subqueries

0 Answers  

---

Give two examples of referential integrity constraints.

1 Answers  

---

What view would you use to determine free space in a tablespace?

0 Answers  

---