Answer Posted / anand

Referential integrity
Referential integrity in a relational database is
consistency between coupled tables. Referential integrity
is usually enforced by the combination of a primary key or
candidate key (alternate key) and a foreign key. For
referential integrity to hold, any field in a table that is
declared a foreign key can contain only values from a
parent table's primary key or a candidate key. For
instance, deleting a record that contains a value referred
to by a foreign key in another table would break
referential integrity. A relational database management
system (RDBMS) enforces referential integrity, normally
either by deleting the foreign key rows as well to maintain
integrity, or by returning an error and not performing the
delete. Which method is used would be determined by the
referential integrity constraint, as defined in the data
dictionary.

Working with TLogs

1896

---

Explain the concepts and capabilities of sql server?

1014

---

Define left outer join in sql server joins?

1011

---

What does sql server mean?

1164

---

What is join query?

938

---

How you trouble shoot when any job fails

1984

---

What is the standby server?

999

---

What are the export options of ssrs?

178

---

What is the difference between stored procedure and user defined functions?

1237

---

How would you use user_constraints table in DB?

1060

---

What are advantages of ssrs or why we should use ssrs?

145

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1068

---

Explain filtered indexes?

1042

---

Explain the difference between control flow and data flow?

1061

---

What are the results of running this script?

975

---