Answer Posted / nishi

A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.

What are the set operators union, union all, minus & intersect meant to do?

983

---

What is a dead lock in oracle?

1111

---

how the indexes are stored in the Oracle Database?

2267

---

How to install oracle database 10g xe?

1009

---

How do we represent comments in oracle?

1041

---

what is a Nested Loop join?

2102

---

What are the uses of linked server and explain it in detail?

1053

---

What is a relational database management system?

1115

---

What are transaction isolation levels supported by oracle?

1058

---

master table and child table performances and comparisons in Oracle ?

2130

---

What is transport network substrate (tns) in oracle?

1039

---

How to experiment a data lock in oracle?

1050

---

What is the quickest way to fetch the data from a table?

1054

---

Please explain compound trigger in oracle?

1051

---

How does one get the view definition of fixed views/tables?

1012

---