what is primary key and foreign key when and where have to use

Answer Posted / chandrika

primary key has unique value, it dostnt contain null values
and duplicate values.


foregin key is primary key of another table

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many file formats are supported to export data?

892


What is the data type of dual table?

705


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1825


How do we get field details of a table?

746


Explain oracle left join with an example?

775


How to check the server version in oracle?

833


How to get the Installed Oracle Version Information ?

865


Explain enable novalidate constraint.

819


What's dateware house and what's clustor with practicle example

1938


How to assign data of the deleted row to variables?

831


Explain about your project and its relation to the current job position you are applying to?

778


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1766


How to resolve name conflicts between variables and columns?

809


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1828


What is transport network substrate (tns) in oracle?

807