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.

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

What is rtm in testing?

0 Answers  

---

What is the difference between an inner and outer join?

0 Answers  

---

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

---

what is d diff between grant,commit,rollback n savepoint

1 Answers  

---

What does the acronym acid stand for in database management?

0 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

What is nosql vs sql?

0 Answers  

---

what is msql? : Sql dba

0 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

Write an sql query to select all records from the table?

0 Answers  

---