Answer / Shashank Braham Dev Narayan

Stored procedures can be faster than SQL queries because they are precompiled, meaning they can reuse the execution plan. This eliminates the need to parse and bind each time the procedure is called, reducing overhead and improving performance.

Write the alter statement to enable all the triggers on the t.students table.

1 Answers  

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

how to create a test table in your mysql server? : Sql dba

1 Answers  

---

What is identity column in sql server?

1 Answers  

---

What is pivot table in sql?

1 Answers  

---

What is cursor explain with example?

1 Answers  

---

How to use sql*plus built-in timers?

1 Answers  

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

1 Answers  

---

What is the difference between left and left outer join?

1 Answers  

---

What is the difference between view and stored procedure?

1 Answers  

---

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

---