Answer Posted / rev

3 basic types
1.entity constraint:
check
not null
null
2.domain constraint:
unique
primary
composite primary key
3.referential constraint:
integrity
foreign

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

924

---

What is table join?

1064

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

992

---

Explain features of analysis services?

921

---

How to automatically create a log when an exception is being received into SQL Server?

1207

---

What is federation member?

114

---

What happens if null values are involved in datetime operations?

898

---

Explain partitioned view?

1018

---

Explain different types of collation sensitivity?

921

---

What are the differences between lost updates and uncommitted dependencies?

1010

---

What is recompile sql server?

988

---

What is left outer join in sql server joins?

965

---

Can you always create a cache of a report?

156

---

What are diverse clauses that form a part of sql?

1014

---

What is difference between rownum and row_number?

909

---