what is the difference between primary key & foreign key?

Answer Posted / mithun

primary key is the unique value,but its not nul values..
this kry is avoided dublicate values

foreign key is always references the primary key.

Is This Answer Correct ?    21 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1672


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

541


Is oracle a language?

522


how may join possible between (requisition with purchase order)

1697


What is backup in Oracle?

567






I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1628


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1657


What is merge in oracle?

558


Explain oracle insert into command?

627


Point out the difference between user tables and data dictionary?

538


How to fetch the row which has the max value for a column?

538


Why cursor variables are easier to use than cursors?

570


How to assign values to data fields in record variables?

581


What do you understand by a database object?

582


what are the default admin accounts in Oracle 10g ?

506