Do foreign keys improve performance?

0 Answers  

---

how can we find the select statement is indexed or not?

3 Answers   CTS,

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

Explain the difference between triggers and constraints?

0 Answers  

---

What is a sql profiler?

0 Answers  

---

---

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

4 Answers  

---

How do I truncate a sql log file?

0 Answers  

---

How to select unique records from a table?

0 Answers  

---

Why schema is used in sql?

0 Answers  

---

What is exit statement?

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,

---

How to disable a trigger name update_salary?

0 Answers  

---