Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137380 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 coalesce function?
What is oracle join syntax?
How to start your 10g xe server?
How to connect to oracle using service name instead of sid?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is catalog in Oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What is a sub query? What are its various types?
How does one get the view definition of fixed views/tables?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to see free space of each tablespace?
Difference between pre-select and pre-query
What is redo log?
How to create a table index?
How many types of tables are there in oracle?
