What are the events on which a database trigger can be based?

0 Answers  

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

what is meant by DML?

5 Answers   HCL,

---

How does a self join work?

0 Answers  

---

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

---

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

---

What are procedures used for?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

Can we create index on primary key?

0 Answers  

---

How do I run sql profiler?

0 Answers  

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---