Answer / suriyaraj

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.

Answer / rajeshwaran

It is a rule defined on a column or a set of columns that
allows to insert or update a value in a table that matches
with the values in the corresponding columns of the related
tabels.

Answer / dhirendra

Referential Integrity means: Whenever parent values are
available, the user can not transact it to Transaction table.

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

---

Is not null in sql?

0 Answers  

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

Give the structure of the function ?

2 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

what is the bond code in materialized view?

0 Answers  

---

what happens if you no create privilege in a database? : Sql dba

0 Answers  

---

Is foreign key mandatory?

0 Answers  

---

What is a recursive stored procedure?

0 Answers  

---

explain normalization concept? : Sql dba

0 Answers  

---

What is sqlcommand?

0 Answers  

---

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

---