Define the terms primary key foreign key and also the
difference between primary and the unique key

Answer Posted / nithya

one more difference is:

a table can have only one primary key but many unique keys.

Is This Answer Correct ?    22 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

562


What is a data lock in oracle?

606


Name the various constraints used in oracle?

562


What is the order of defining local variables and sub procedures/functions?

597


Explain about your project and its relation to the current job position you are applying to?

538






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

619


How do I know if oracle client is installed on windows?

494


what is the use of system.effective.date variable in oracle?

669


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1771


Explain the difference between sql and oracle?

574


How to recover a dropped table in oracle?

601


Why we use bulk collect in oracle?

532


What is Trigger in Oracle?

569


What is the string concatenation operator in oracle?

566


How to enter a new row into a table interactively?

544