Interested to Buy Any Domain ? << Click Here >> for more details...
Define the terms primary key foreign key and also the
difference between primary and the unique key
- 2 Answers
- 11314 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pugal
Primary Key : The primary key of a relational table
uniquely identifies each record in the table
Foreign Key : These keys are used to create relationships
between tables.
Unique Key : In relational database design, a unique key is
a candidate key to uniquely identify each row in a table. A
unique key comprises a single column or set of columns
Difference between primary and unique key :
primary key not allows null values
unique key allows null values
| Is This Answer Correct ? | 33 Yes | 12 No |
Answer / nithya
one more difference is:
a table can have only one primary key but many unique keys.
| Is This Answer Correct ? | 22 Yes | 3 No |
What are the different type of Segments ?
where we have to use ON clause and where we have to use USING clause in JOINS
How to change program global area (pga) in oracle?
What is a static data dictionary in oracle?
Explain about your project and its relation to the current job position you are applying to?
What are the factors causing the reparsing of SQL statements in SGA?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How to find out what oracle odbc drivers are installed?
What is a table in oracle?
How to get execution statistics reports on query statements?
Explain oracle 12c new features for developers?
What are set operators?
Oracle General 
