Answer / sawant

It consists of

one or more data files.

one or more control files.

two or more redo log files.

The Database contains

multiple users/schemas

one or more rollback segments

one or more tablespaces

Data dictionary tables

User objects (table,indexes,views etc.,)

The server that access the database consists of

SGA (Database buffer, Dictionary Cache Buffers,
Redo log buffers, Shared SQL pool)

SMON (System MONito)

PMON (Process MONitor)

LGWR (LoG Write)

DBWR (Data Base Write)

ARCH (ARCHiver)

CKPT (Check Point)

RECO

Dispatcher

User Process with associated PGS

Answer / nishi

It consists of - one or more data files

- one or more control files

- two or more redo log files

The database contains - Multiple users/schema's

- one or more rollback segments

- one or more tablespaces

- Data dictionary tables

User objects (table, indexes, views etc.)

Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com

0 Answers  

---

What are triggers in oracle?

0 Answers  

---

What is the difference between SQL, DDL, and DML?

7 Answers   BeBo Technologies, Wipro,

---

What is a connect identifier?

0 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

How to use subqueries with the exists operator in oracle?

0 Answers  

---

How data locks are respected in oracle?

0 Answers  

---

how to i write the query 'NISHI' TO N I S H I

4 Answers   Attra, Metric Stream,

---

How do you ensure database security?

1 Answers  

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

0 Answers  

---

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---