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 is an oracle user account?

573


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1642


What is meant by joins? List out the types of joins.

520


What is a data lock in oracle?

607


What is the use of file param in imp command?

642






Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1572


Explain what are the uses of rollback segment?

580


What is set verify off in oracle?

573


Is primary key indexed by default in oracle?

540


Hi Can any one tell me what are the API's used in requisition import.

1483


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

585


What do you mean by a deadlock?

515


How many memory layers are in the oracle shared pool?

637


IS it possible to built the oracle database without setting the kernal parameters?

1759


What are set operators?

644