Answer Posted / s.munna

Normalisation is basically avoid redundent data in database
for saving memory space and faster manipulation of data
keep and insert ,update , delete anamollies.....

Where the sql database files are stored?

1010

---

What are aggregate functions in sql?

1151

---

What is the size of partition table?

1041

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2478

---

what is the difference between truncate and delete statement? : Transact sql

1057

---

Explain the select statement in sql?

1105

---

What is difference between stored function and application function?

1190

---

Does truncate require commit?

963

---

What is the importance of sqlcode and sqlerrm?

1345

---

Is drop table faster than truncate?

985

---

What are properties of the transaction?

996

---

What is the difference between delete and truncate statement in sql?

1060

---

Can you rollback after commit?

975

---

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

4016

---

How do temporal tables work?

951

---