What is the use of triggers?

0 Answers  

---

How can we avoid duplicating records in a query?

0 Answers  

---

Can a key be both primary and foreign?

0 Answers  

---

Which is better trigger or stored procedure?

0 Answers  

---

How many indexes can be created on a table in sql?

0 Answers  

---

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

How many functions are there in sql?

0 Answers  

---

What is the difference between inner join and natural join?

0 Answers  

---

What is a boolean in sql?

0 Answers  

---

What is PL/SQL Records?

0 Answers  

---