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
- 11175 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 is flashback in Oracle?
How to use null as conditions in oracle?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
What is Database Link ?
What is Trigger in Oracle?
What is Partitions in Table ?
How to build data dictionary view an new database?
How do we switch from init.ora file to asp file?
What is a nested table and how is it different from a normal table?
what is data independence exactly? give an example
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to create additional tablespaces for an new database?
Oracle General 
