Answer Posted / orawhiz

Temporary segments are created by ORACLE when a SQL statement
needs a temporary work area to complete execution. When the
statement finishes execution, the temporary segment extents are
released to the system for future use.

What to do if dba lost the system password?

1148

---

When do you get a .pll extension in oracle? Explain its importance

1016

---

What is oracle in java?

949

---

Difference between the “verify” and “feedback” command?

1343

---

Define oracle database

1025

---

How to execute a stored procedure in oracle?

1066

---

what is meant by magic query

2160

---

How to calculate date and time differences in oracle?

1021

---

Explain oracle left join with an example?

986

---

Explain the use of Merge statement in oracle 11g

1011

---

Can I create users through internet explorer in oracle 10g?

1067

---

What is the relationship among database, tablespace and data file?

965

---

How to define an anonymous procedure without variables?

1079

---

How to find the duplicate rows count from employees table in oracle?

1067

---

Explain what are the uses of rollback segment?

991

---