what is the difference between primary key & foreign key?

Answer Posted / muneer

Primary Key is unique Key entire the table and which is
also NOT NULL
where as foriegn key is the null & which references the
primary key .

Is This Answer Correct ?    147 Yes 28 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by cdb and pdb in oracle 12c?

641


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

548


What is tns service name?

622


Explain the use of consistent option in exp command.

552


Explain an exception and its types?

611






What happens if variable names collide with table/column names?

584


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1523


What is the max number of columns in an oracle table?

515


Explain the difference between a procedure and a function?

561


How can windows applications connect to oracle servers?

524


What to do if the startbd.bat failed to start the xe instance?

611


how to handle exceptions in post production

950


List the parts of a database trigger.

581


What are the benefits of ordbms?

619


What is an oracle recycle bin?

551