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 do we accept inputs from user during runtime?

0 Answers  

---

What's the procedure?

0 Answers  

---

what is a stored procedure? : Sql dba

0 Answers  

---

Why function is used in sql?

0 Answers  

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

Is progress software supports to ( pl/sql )?

0 Answers  

---

Why query optimization is needed?

0 Answers  

---

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

---

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

---

How do you delete a table?

0 Answers  

---

What is clause in sql?

0 Answers  

---

what is union? : Sql dba

0 Answers  

---