Answer Posted / vipul.solanki

Index is use for the performance to retrieve data from table.
1 . index automatically created when create PK or UK
2 . Explicitly create index

there is three type of index

1.unique index
2.cluster index
3.non-cluster index

What are the differences between blob and clob in oracle?

1039

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4302

---

How to handle a single quote in oracle sql?

979

---

What is the difference between PFILE and SPFILE in Oracle?

1000

---

How oracle handles dead locks?

1027

---

What are the different pseudo commands? Explain in general?

1028

---

How to define a specific record type?

1041

---

How to export your own schema?

973

---

What is oracle rownum?

896

---

Design database draw er diagram for a certain scenario ?

4535

---

Difference between inner join vs where ?

986

---

Point the difference between translate and replace?

1031

---

How to create a new table in your schema?

1038

---

What are joins, explain all types of joins?

2227

---

Difference between varchar and varchar2 data types?

1127

---