Answer / Aditya Tiwari

Stored procedures are PL/SQL programs that reside within the database, while application procedures (functions and subprograms) exist within the application. Stored procedures can be invoked by multiple applications, making them more efficient as they reduce network traffic and improve performance. On the other hand, application procedures provide a way to modularize complex logic within an individual application.

What is a pl/sql block?

1 Answers  

---

i have some prob lem to tell me about my self in interview first round ...

1 Answers  

---

What are indexes, and what are the different types?

3 Answers  

---

Mention what are different methods to trace the pl/sql code?

1 Answers  

---

Can we commit inside a trigger?

1 Answers  

---

What does := mean in pl sql?

1 Answers  

---

What is forward declaration in pl sql?

1 Answers  

---

Explain what is sql?

1 Answers  

---

What is trigger in pl sql?

1 Answers  

---

what are sequences

1 Answers  

---

How do I truncate a sql log file?

1 Answers  

---

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  

---