Why do you use stored procedures and state some of its disadvantages?

975

---

How to convert a date to char in oracle? Give one example.

1006

---

What is the difference between translate and replace in oracle?

1120

---

What are the different types of synonyms?

1083

---

How do you store pictures in a database?

957

---

What is the use of file param in imp command?

1119

---

What is a system tablespace?

1011

---

In the oracle version 9.3.0.5.0, what does each number shows?

1232

---

What are the different types of modules in oracle forms?

955

---

What are the limitations of check constraint?

968

---

How to convert a string to a date in oracle database?

1002

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

972

---

Can you create a synonym without having a table?

989

---

What are the components of logical database structure in oracle database?

1033

---

What is the usage of save points in oracle database?

917

---