Answer Posted / rishi anand

Stroed procedures are basically set of sql statements.User
defined stored procedures are created by users in which
they can use functions,procedures to get the desired result
from database.

Do foreign keys improve performance?

963

---

Can we use insert statement in function?

936

---

What does pragma mean?

967

---

What is rtm in testing?

1037

---

what is rollback? : Sql dba

1019

---

How do you declare a user-defined exception?

958

---

how mysql optimizes distinct? : Sql dba

999

---

What is string data type in sql?

1045

---

What are the different ddl commands in sql?

1064

---

What is left join in sql?

1003

---

Is sql a oracle?

910

---

Does access use sql?

964

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1013

---

What is consistency?

1060

---

Is coalesce faster than isnull?

906

---