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.

What is nolock hint in sql server 2008

1113

---

What are the pre-defined functions in the sql server?

1093

---

What languages bi uses to achieve the goal?

996

---

How to set the current database in ms sql server?

1069

---

What are different type of Collation Sensitivity?

991

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1032

---

What is pessimistic concurrency?

969

---

Explain what is the function of sql server agent windows service?

986

---

Where can you add custom error messages to sql server?

1107

---

Mention the different types of triggers?

1099

---

How to transfer an existing table from one schema to another schema in ms sql server?

972

---

What are the differences between clustered and non-clustered index?

1016

---

What is difference between standardization and normalization?

1083

---

What is system stored procedures?

1036

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2207

---