Can you please differentiate between a primary key and a unique key?

0 Answers  

---

What is a subquery in a select query statement in ms sql server?

0 Answers  

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---

How do you delete duplicate records in sql server?

0 Answers  

---

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

---

What is DAC? what is the use of it?

1 Answers   Wipro,

---

How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,

---

Tell me can we use custom code in ssrs?

0 Answers  

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

What is indexing?

0 Answers   AOL,

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

---