Answer Posted / sachin

we can switch from init.ora file to a sp file with the help
of the command
create spfile from
pfile='c:\oracle\database_name\pfile\init.ora'

How would you begin to troubleshoot an ORA-3113 error?

2067

---

What is pragma autonomous transaction in oracle?

1042

---

State the difference between a primary key and foreign key?

921

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1030

---

What is the difference between 10g OEM and 11g OEM?

950

---

 What are the oracle DML commands possible through an update strategy?

1042

---

How to compare dates in oracle sql?

1087

---

What is the use of aggregate functions in oracle?

1013

---

How translate command is different from replace?

1060

---

What is coalesce function?

1053

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2217

---

What are the different pseudo commands? Explain in general?

1058

---

What is a proxy class?

1018

---

How data locks are respected in oracle?

1048

---

Explain overloading. Can functions be overloaded?

965

---