How many columns can exist together per table?

0 Answers   Cap Gemini,

---

What's the difference between a primary key and a unique key?

4 Answers  

---

What is a view and what are its advantages?

0 Answers  

---

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

---

Mention the 3 ways to get a count of the number of records in a table.

0 Answers  

---

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

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

4 Answers  

---

Which are new data types introduced in sql server 2008?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

Explain about link server in sql server?

0 Answers  

---

How to count duplicated values in a column in ms sql server?

0 Answers  

---

Do you know what are the steps to process a single select statement?

0 Answers  

---