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 the types of operators available in sql?

0 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

What is function and procedure?

0 Answers  

---

What is self-join and what is the requirement of self-join?

0 Answers  

---

What is the difference between nested table and varray?

0 Answers  

---

can we update a view which is created from two tables

11 Answers  

---

How you improve the performance of sql*loader? : aql loader

0 Answers  

---

Why do we need view in sql?

0 Answers  

---

What is trigger in sql? Explain

0 Answers  

---

Why is sharding used?

0 Answers  

---

Can two tables have same primary key?

0 Answers  

---

What is the difference between a subquery and a join?

0 Answers  

---