what is the difference between primary key & foreign key?
Answer Posted / anand
Primary key is used to identify a row in a table and it
doesnot allow null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between translate and replace?
20. Using a set operator, display the client number of all clients who have never placed an order.
How to write a left outer join with the where clause in oracle?
How to omit columns with default values in insert statement in oracle?
How to define an external table with a text file?
How to find out what oracle odbc drivers are installed?
what's query optimization and without use of IN AND Exist can we get another way data from query
How can I get column names from a table in oracle?
What is control file used for?
Does facebook use oracle?
what happened to the global index when I truncate the data in one of the partition?
Differentiate between translate and replace?
How do you find current date and time in oracle?
Explain table?
What do you mean by redo log file mirroring?