Answer Posted / pravin

sequence is sharable object in database which is use to
generate unique number
use of sequence is like
insert into table(emp_id,name)values
(sequencname.nextvalue,name)
&
cache is the memory use to how manu values preallocates in
memory & keep in memory defined in cache.
by default 20 values can be stored in cache.

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1810

---

What is an oracle function?

1071

---

How to use like conditions in oracle?

993

---

How does the on-delete-cascade statement work?

1058

---

Why do we use bulk collect in oracle?

1009

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2842

---

What do you mean by merge in oracle and how can you merge two tables?

904

---

What is a tns service name?

941

---

How to get maxsal , minsal, ename department wise in single query

1499

---

What is a procedure in oracle?

1073

---

What is the difference between translate and replace in oracle?

1112

---

How is it different from a normal table?

966

---

Explain oracle left join with an example?

953

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2183

---

What is max rowid in oracle?

963

---