Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137633 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sripathi venkata ramesh
I am Sripathi Venkata Ramesh from Gudivada and the answer
is mentioned below
Primary key: A Primary key is a column or group of columns
used to uniquely identify each row in a table like
It defines the column as a Mandatory column.
The data held across the column must be unique.
By default it creates clustered index.
It does not allow null values and duplicate values
Foreign key: A Foreign key is a column or group of columns
whose values are derived from the primary key of some other
table
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the different types of failures that occur in Oracle database?
What is the purpose of save points in oracle database?
How does oracle handle read consistency?
What is the difference between sharding and replication?
How to run the anonymous block again?
What is proxy method?
What is a procedure in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to define default values for formal parameters?
What is the difference between Delete, Truncate and Drop in Oracle?
How to connect ms access to oracle servers?
How many anonymous blocks can be defined?
What is a partition in oracle?
how to join query for one source type is oracle another source type is sql server ?
How to convert csv to table in oracle?
