If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

How would you pass hints to the sql processor?

0 Answers  

---

Which sql statement is used to return only different values?

0 Answers  

---

Is natural join same as inner join?

0 Answers  

---

What is keys and its types?

0 Answers  

---

---

What is correlated sub-query?

7 Answers   Oracle,

---

What is the difference between cross join and natural join?

0 Answers  

---

What are the different types of constraints?

0 Answers  

---

How much does sql cost?

0 Answers  

---

How do you know if a relationship is 2nf?

0 Answers  

---

What is sql and also describe types of sql statements?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---