Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

Explain boyce and codd normal form(bcnf)?

0 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

Define model database?

0 Answers  

---

What is a file group?

0 Answers  

---

how to rename the table

3 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---

What does set rowcount do?

0 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---