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 is pl sql commands?

0 Answers  

---

Why use truncate instead of delete?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

Define the select into statement.

0 Answers  

---

What are different functions in sql?

0 Answers  

---

---

Explain what is dbms?

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

What is consistency?

0 Answers  

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

---

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

---

What are the advantages of indexing?

0 Answers  

---

What is indexes?

0 Answers  

---