Describe Referential Integrity ?



Describe Referential Integrity ?..

Answer / orawhiz

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.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Oracle General Interview Questions

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,


Explain about integrity constraint?

0 Answers  


Can the default values be assigned to actual parameters?

1 Answers  


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

0 Answers  


12. Display the client name in upper case only and in lower case only.

1 Answers   Wipro,






Can you use a commit statement within a database trigger?

4 Answers  


How to install oracle odbc drivers?

0 Answers  


Explain alias?

0 Answers  


How to use "if" statements on multiple conditions?

0 Answers  


How do I use os authentication with weblogic jdriver for oracle and connection pools?

0 Answers  


What is truncate oracle?

0 Answers  


What is oracle analytical function?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)