Answer Posted / charvi

Architecture describes in terms of phycical and logical structure.
Physical--CRD files,Loigal FIles--Tablespace.

Instance:Collection of System Global Area and Background Process.

System Global Area: It Consists of Several Memory structures.
1) Library Cache 2) Data Dictionary Cache 3) Data Buffer Cache $) Redo Buffer Cache 5) Java pool,Large Pool,Stream Pool.

Background Process:
1)Process Monitor(PMON) 2) system Monitor(SMON) 3)Data Base Writer(DBWR) 4)Log Writer(LGWR) 5)Check Point.

Database: The Collection of Control file,Database file,Redo log File.

Teradata: How can we know the indexed column in a table?

1939

---

Can a Tablespace hold objects from different Schemes in Oracle?

1082

---

What is the use of Oracle Control File?

1109

---

What is an Oracle Data Dictionary?

1161

---

What is an oracle database schema?

1163

---

What is an Oracle Rollback Segment?

1160

---

What is an Integrity Constrains in Oracle?

1232

---

Can a View based on another View in Oracle?

1070

---

What is an Oracle Data Block?

1116

---

What are the consideration at tehe migration of Oracle 9i to 10G.

3112

---

What are the uses of Oracle Rollback Segment?

1175

---

What are Oracle Schema Objects?

1150

---

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2757

---

What is an Oracle SYSTEM tablespace and when is it Created?

1164

---

What is the function of Redo Log in Oracle?

1267

---