Define the terms primary key foreign key and also the
difference between primary and the unique key
- 2 Answers
- 10681 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 database links ?
How to restrict the duplicate records in table valuesets
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
how to unbreak sequence numbers during intereptions
What are the uses of Database Trigger ?
What is a partition in oracle?
Without giving condition how to retrieve the unmatched records from table.
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
What privilege is needed for a user to create tables in oracle?
Oracle General 
