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

What happens if recursive calls get out of control?

771


definition of cluster and non-clustered index?

2723


What are the advantages of oracle 12c?

876


Explain view?

827


what are archived logs?

1972


How would you best determine why your MVIEW couldnt FAST REFRESH?

1659


How to create additional tablespaces for an new database?

817


How to export data to a csv file?

884


Explain the blob datatype?

832


How to convert numbers to characters in oracle?

815


How many types of tables are there in oracle?

830


Explain constraining triggers.

878


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

846


How to open and close an explicit cursor in oracle?

828


How do I spool to a csv formatted file using sqlplus?

752