Answer Posted / anjali

Sql is a standalone set of commands. Pl sql is procedural extension to sql where we embed sql statements inside pl sql block so that we can achieve re-usability of code .

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

997

---

what is a materialized view? : Sql dba

1062

---

What is a unique key and primary key and foreign key?

969

---

What is sql resultset?

989

---

Is primary key an index?

991

---

How many triggers can be applied to a table?

1063

---

Does pl sql work in mysql?

983

---

what is isam? : Sql dba

1009

---

what are date and time intervals? : Sql dba

1057

---

What are three advantages to using sql?

1019

---

What is sql*loader?

1192

---

what are set operators in sql? : Sql dba

1054

---

What can sql server reporting services do?

1111

---

what is denormalization. : Sql dba

1113

---

What is sql exception?

975

---