Answer / rajesh

To establish a parent child relationship between two tables
and to prevent invalid data entry into the table , we make
set of rules on a column is called Referential integrity.

Answer / mallikarjuna.anumala

A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to
be performed on dependent data as a result of any action on
referenced data.

Answer / pravin kadam

A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to
be performed on dependent data as a result of any action on
referenced data.

What are tables and fields in the database?

0 Answers  

---

What are stuff and replace function?

0 Answers  

---

what is “go” in t-sql? : Transact sql

0 Answers  

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

---

---

Which are the different types of indexes in sql?

0 Answers  

---

Can triggers stop a dml statement from executing on a table?

0 Answers  

---

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

0 Answers  

---

How can the performance of a trigger be improved?

0 Answers  

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  

---

Which is faster joins or subqueries?

0 Answers  

---