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 2nf?

0 Answers  

---

What are the SQL clauses supported in the link property sheet ?

1 Answers  

---

What are views in dbms?

0 Answers  

---

What database should I learn first?

0 Answers  

---

What are the characteristics of data in the database?

0 Answers  

---

What is the use of SHOW option in IMP command ?

1 Answers  

---

What are the main components of a database in healthcare?

0 Answers  

---

determine the minimum salary of the employee and his details who join on the same date

3 Answers  

---

What is in a database?

0 Answers  

---

Mention a query to calculate the even and odd records from a table

0 Answers  

---

What is the relationship?

0 Answers  

---

Define ddl interpreter.

0 Answers  

---