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.

How to test for null values?

0 Answers  

---

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---

How to load data with sql*loader?

0 Answers  

---

How can you view the errors encountered in a trigger?

0 Answers  

---

---

what is inline view?

15 Answers  

---

What does over partition by mean in sql?

0 Answers  

---

How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

---

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

What is sql and its types?

0 Answers  

---

Which is better stored procedure or query?

0 Answers  

---