Answer Posted / daynik

Referential integrity is a database concept that ensures
that relationships between tables remain consistent. When
one table has a foreign key to another table, the concept of
referential integrity states that you may not add a record
to the table that contains the foreign key unless there is a
corresponding record in the linked table. It also includes
the techniques known as cascading update and cascading
delete, which ensure that changes made to the linked table
are reflected in the primary table.

Explain full-text query in sql server?

1009

---

What are the advantages of paper records?

969

---

What is a sql join?

1022

---

How do you delete a trigger?

981

---

How many types of triggers in sql server?

1032

---

How to enable/disable indexes?

1068

---

How can a user-defined datatype be created?

985

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1096

---

What is the difference between stored procedure and functions?

1135

---

In which tcp/ip port does sql server run? Can it be changed?

991

---

What is use of @@ spid in sql server?

1213

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1099

---

What is PROJECTION Operation?

1022

---

When cursors are useful?

1104

---

What is check constraint in sql server?

1002

---