Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 139150 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 the quickest way to export a table to a flat file?
How to pass a parameter to a cursor in oracle?
What is Reduced List of Values?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Describe the types of sub query?
How to create a single index for multiple columns?
Can group functions be used in the order by clause in oracle?
What is a read write transaction in oracle?
How to omit columns with default values in insert statement in oracle?
State some uses of redo log files?
What is a partition in oracle?
When do we use group by clause in a sql query?
Which is better Oracle or MS SQL? Why?
What is dual table oracle?
What privilege is needed for a user to create tables in oracle?
