What is the difference between the Primary and Foreign key?

Answer Posted / suma

Primary key is unique index and non null coulum in a table.
While foreign key can have repeated values.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by exception handling in pl/sql?

568


What is indexes?

534


What is an exception in PL/SQL? What are the two types of exceptions?

620


Explain architecture of sql server notification services?

616


Difference between table function and pipelined function?

578






what is the difference between char_length and length? : Sql dba

567


What is compound trigger?

553


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

766


What is transaction control language (tcl)?

627


What is number function in sql?

523


What is the purpose of cursors in pl/sql?

631


Should I use mbr or gpt?

531


What packages are available to pl/sql developers?

590


Which one is faster ienumerable or iqueryable?

479


How many functions are there in sql?

532