What are the types of normalization?

0 Answers  

---

Is it true, that there is no difference between a rule and a check constraint?

0 Answers  

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

Define primary key?

0 Answers  

---

What are the hotfixes and patches in sql server?

0 Answers  

---

What is user-defined multi-statement table-valued function?

0 Answers  

---

How to disconnect from a sql server using mssql_close()?

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,

---

Does an index slow down updates on indexed columns?

0 Answers  

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

What is analysis service repository?

0 Answers  

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---