Answer / guest

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

Explain top-n analysis in DBMS.

0 Answers   ITC Indian Tobacco Company,

---

Explain why an information gap exists in most organizations.

0 Answers  

---

What is the quickest sorting method to use?

0 Answers  

---

what is the difference between unique and primary key

5 Answers  

---

Explain all codd's rules for relational database system?

0 Answers  

---

What are types of dbms?

0 Answers  

---

Explain the Importance of Data Normalization.

1 Answers  

---

What is sql and where is it used?

0 Answers  

---

What is dbms_output put_line?

0 Answers  

---

what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?

0 Answers   NIIT, TCS,

---

What is Database testing and What are ways of writing test cases for database testing?

0 Answers   Ittiam Systems,

---

What are the types of tables in database?

0 Answers  

---