Referential Integrity is a DataBase concept that ensures the relationship between tables remainsconsistent, where one table has a foreign key reference to the other table which is declared asprimary key.
This is one of the typical SQL Server interview questions and also the favorable question of the interviewers. The interviewers ask this question to check your skills on converting the table data in to XML format but many of your developer friends fails i
A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the ACID (Atomicity, Consistency, Isolation, and Durability) properties, to qualify as a transaction: