how will u find statistics of a database objects?

2 Answers   iFlex,

---

Show the two pl/sql cursor exceptions.

0 Answers  

---

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

---

what is difference between decode and case function?

2 Answers  

---

What are the types of views in sql?

0 Answers  

---

---

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

---

What is difference between select statement and cursor

3 Answers   JDA,

---

Does indexing improve query performance?

1 Answers  

---

Can I learn sql in a week?

0 Answers  

---

How many primary keys can a table have?

0 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  

---

in procedure how to return a value

3 Answers   Wipro,

---