How do you know if a relationship is 2nf?

0 Answers  

---

Can we insert data into materialized view?

0 Answers  

---

What is exception? What are the types of exceptions?

0 Answers  

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

Why we use joins in sql?

0 Answers  

---

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,

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

Can we use update in sql function?

0 Answers  

---

What is latest version of sql?

0 Answers  

---

How is pl sql different from sql?

0 Answers  

---

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

1 Answers   Fidelity, Oracle,

---