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
- 11101 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to unlock the sample user account in oracle?
How to convert dates to characters in oracle?
Can we call procedure inside function in oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What are the set operators union, union all, minus & intersect meant to do?
What is meant by joins?
Can a formula column referred to columns in higher group ?
How oracle handles dead locks?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain the use of Merge statement in oracle 11g
Please explain oracle left join with an example?
What are the execution control statements?
What is MTTR advisor in Oracle?
How to select some rows from a table in oracle?
