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

Answer Posted / prashant

primary key has a unique & it is only one in a
databasewhile fkey is not unique. it is based on primary key

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to list all indexes in your schema?

584


Explain database link?

668


what is a Nested Loop join?

1568


State all possible different index configurations a table can possibly have?

572


What is the difference between translate and replace in oracle?

659






What is raw datatype in oracle?

583


How to drop a stored function?

678


Explain what are the different type of segments?

580


How to define a specific record type?

624


What is procedure overloading in oracle?

546


What is open database communication (odbc) in oracle?

549


Difference between varchar and varchar2 data types?

668


What is oracle and what are its different editions?

581


What is the difference between pre-select and pre-query?

621


What do database buffers contain?

567