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,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

Tell me what is use of except clause? How it differs from not in clause?

0 Answers  

---

List some major differences between triggers and stored procedures?

0 Answers  

---

How to provide Security for package?

1 Answers   Convergys,

---

What are the different ways you can create databases in sql server?

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

---

Tell me about builtinadministrator?

0 Answers  

---

What are pessimistic lock and optimistic lock?

0 Answers  

---

What is page in sql server?

0 Answers  

---

Explain rdbms?

0 Answers  

---