Answer Posted / ramprakash

Instead of Triggers
After Triggers

Is coalesce faster than isnull?

703

---

Why we use stored procedure instead of query?

710

---

When are we going to use truncate and delete?

716

---

What is scalar and vector?

720

---

Why do we use procedures in pl sql?

721

---

---

Can you load data into multiple tables at once? : aql loader

800

---

What is nvarchar max in sql?

750

---

How will you distinguish a global variable with a local variable in pl/sql?

844

---

What is sharding in sql?

738

---

Can we rollback truncate?

719

---

how to enter binary numbers in sql statements? : Sql dba

707

---

Can a key be both primary and foreign?

718

---

What are the various restrictions imposed on view in terms of dml?

692

---

what are the performance and scalability characteristics of mysql? : Sql dba

723

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

785

---