What is the difference between the SQL*Loader and IMPORT utilities?

1 Answers  

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

0 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

0 Answers  

---

What is the difference between recovery and restoring of the oracle database?

0 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

10 Answers   TCS,

---

How would you go about increasing the buffer cache hit ratio?

0 Answers  

---

How to find locks exists in a table or not?

1 Answers   HCL,

---

Explain the use of table functions.

0 Answers  

---

What is database schema?

4 Answers   Infosys,

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,

---

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---