Answer Posted / orawhiz

ORACLE database's data is stored in data blocks. One data block
corresponds to a specific number of bytes of physical
database space on disk.

What privilege is needed for a user to create indexes in oracle?

584

---

What is the difference between substr & instr functions?

607

---

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

3878

---

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

2401

---

How to enter a new row into a table interactively?

561

---

---

How does Oracle guarantee data integrity of data changes?

1946

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1228

---

What is a proxy class?

570

---

What is the difference between sharding and partitioning?

513

---

Give the advantages and disadvantages of clusters.

585

---

What is integrity and what is constraint??Explain with example

1710

---

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

572

---

what is the difference between data migration and production migration.

1818

---

How to start a new transaction in oracle?

597

---

Difference between the “verify” and “feedback” command?

790

---