Answer Posted / kamal pratap singh

Normalization is the process of reduce the redundency in
database which is usefull for maintain the database very
smoothly and fast processing.

What is the sid in oracle?

544

---

Are truncate and delete commands same? If so why?

662

---

Design database draw er diagram for a certain scenario ?

4109

---

What are the limitations oracle database 10g xe?

583

---

What is meant by joins? List out the types of joins.

535

---

---

What is the sql query to concatenate column values from multiple rows in oracle?

575

---

What happens if you lost a data file?

594

---

What is oracle thin client?

548

---

How to assign a table row to a record variable?

590

---

Explain the use of compress option in exp command.

556

---

What is oracle analytical function?

541

---

Explain a synonym?

614

---

What do you understand by a database object?

597

---

How to revoke create session privilege from a user in oracle?

568

---

What is the difference between a user and a schema in oracle?

575

---