Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 135171 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 is a read write transaction in oracle?
candidate key is subset of super key but not vice-verse explain
How much memory your 10g xe server is using?
What is the use of aggregate functions in oracle?
What the is the diff between local index and global index. give some example.
What are dml statements in oracle?
What are the different types of trigger and explain its various uses and functions?
What is the usage of save points in oracle database?
how the indexes are stored in the Oracle Database?
How to rollback the current transaction in oracle?
How do I spool in oracle?
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?
How to export your own schema?
What is Library Cache in Oracle?
How to convert csv to table in oracle?
