Answer Posted / sudev kuma rmishra

two types
A.implicit B.explicit

A.implicit index

automatically created when we mention primary key or unique key

B.explicit index

these are created by user
and examples are
1.simple/normal index
2.composite index
3.unique index
4.bitmap index
5.partition index
6.function index

Explain the use of ignore option in imp command.

983

---

How to use null as conditions in oracle?

1012

---

Describe an oracle table?

999

---

When do I need to use a semicolon vs a slash in oracle sql?

1032

---

How can windows applications connect to oracle servers?

997

---

What operating systems are supported by oracle database 10g xe?

989

---

In the oracle version 9.3.0.5.0, what does each number shows?

1237

---

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

1046

---

What is the difference between substr and instr?

984

---

What are the different types of trigger and explain its various uses and functions?

1018

---

What are the logical operations?

1070

---

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

1012

---

What is truncate oracle?

922

---

Can a formula column be obtained through a select statement ?

2272

---

Oracle

2325

---