what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

What are the two characteristics of a primary key?

0 Answers  

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

In pl/sql, what is bulk binding, and when/how would it help performance?

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  

---

Explian rowid, rownum?

0 Answers  

---

What is database sql?

0 Answers  

---

How many types of cursors supported in pl/sql?

0 Answers  

---

Explain what is table in a database?

0 Answers  

---

Wat is SGA ?

3 Answers   ABB,

---

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

---