Answer / orawhiz

A Database contains one or more Rollback Segments to
temporarily store "undo" information.

Answer / gvmahesh

roll back segment means it is a an dynamic memory location
for storing all the transactional(INSRT,UPDATE,DELETE) data.
untill we commited or rollback that data.

Answer / mohan

rollback is undo the sql and plsql statments.

How to start a specific oracle instance?

0 Answers  

---

types of indexes and the rationale behind choosing a particular index for a situation.

0 Answers  

---

How to concatenate two text values in oracle?

0 Answers  

---

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

What is Water Mark in Oracle?

7 Answers   Oracle,

---

Is primary key = unique key,not null? If yes,please explain IF No,please explain

8 Answers   Genpact,

---

Is insert autocommit in oracle?

0 Answers  

---

What are the composite date types in oracle?

6 Answers   HCL,

---

Explain the blob datatype?

0 Answers  

---

Select the Nth lowest value from a table?

4 Answers  

---

Does oracle charge for java?

0 Answers  

---