What is database normalization?

7 Answers   Deloitte, Digicel, JPMorgan Chase, Verifone,

---

What is the security model used in sql server 2005?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

How to write a query with a full outer join in ms sql server?

0 Answers  

---

What is database mirroring?

0 Answers  

---

What are different types of subquery?

0 Answers  

---

What are the underflow and overflow behaviors on float literals?

0 Answers  

---

What is open database communication (odbc)?

0 Answers  

---

Define the term DML, DDL and DTL?

1 Answers  

---

What does null mean?

0 Answers  

---

What guidelines should be followed to help minimize deadlocks?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---