What are sql functions? Describe the different types of sql functions?

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,

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

---

How can we schedule the procedure to run automatically ?

3 Answers  

---

---

What type of join is sql join?

0 Answers  

---

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

0 Answers  

---

Explain what is sql?

0 Answers  

---

can sql servers linked to other servers like oracle? : Sql dba

0 Answers  

---

What is the difference between stored procedure and view?

0 Answers  

---

What is the purpose of primary key?

0 Answers  

---

What is data abstraction in sql?

0 Answers  

---