Answer Posted / nitesh

It is mainly used in referential integrity constraints.

When you use primary key/candidate key of one relation(say,
r1) as foreign key in other relation(say, r2), you want
changes made to primary key/candidate key of r1 must reflect
in foreign key of r2. And this can be achieved by CASCADE
constraint.
eg. consider two relations account, branch(with primary key
branch_name)

create table account(.....
foreign key branch_name references branch
on delete cascade
on update cascade
..........)

Can you explain what are commit and rollback in sql?

944

---

What is an execution plan? When would you use it?

980

---

Explain table valued parameters in sql server? Why tvp used?

1024

---

Explain aggregate functions?

1086

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

984

---

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? : Sql server administration

978

---

What do you mean by data integrity?

1082

---

What happens if an integer is too big for int date type?

978

---

What are the differences between decimal and float in ms sql server?

1253

---

What does normalization do to data?

1075

---

What are the approximate numeric data types?

942

---

Explain the properties of sub-query in sql server?

1019

---

What is the downside of using udf?

1109

---

How to list all tables in the database using odbc_tables()?

1052

---

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

---