what is the difference between primary key & foreign key?

Answer Posted / dimna

primay key uniquely identifies records in relation.
in a table only one primary key.But may have more than one
foreign key.

Is This Answer Correct ?    17 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the execution control statements?

621


What is ceil and floor in oracle?

579


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1366


Design database draw er diagram for a certain scenario ?

4105


How will you identify oracle database software release?

527






How can I combine multiple rows into a comma-delimited list in oracle?

583


How to get maxsal , minsal, ename department wise in single query

1026


How to create a new table by selecting rows from another table?

555


Explain the use of log option in exp command.

535


What is the fastest query method to fetch data from the table?

866


What is the relation of a user account and a schema in oracle?

592


How to open and close an explicit cursor in oracle?

579


Why do you use stored procedures and state some of its disadvantages?

567


Can you have more than one content canvas view attached with a window ?

1817


Explain an exception and its types?

611