What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers  

---

Describe what redo logs are.

1 Answers  

---

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

---

---

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,

---

how to create an user in oracle 10g.please give me an example..

1 Answers  

---

what is sql*loader parameters and where we will use it.

1 Answers   Accenture,

---

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

0 Answers  

---

How do you use trigger to create mutating state of table

2 Answers   TCS,

---

How can you rebuild an index?

1 Answers  

---