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
- 11068 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 |
How to divide query output into groups in oracle?
What are the types of partitions in oracle?
What is the difference between sharding and partitioning?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to create a table index?
Explain constraining triggers.
what is difference between DBMS and RDBMS?
Explain a synonym?
How can I introduce multiple conditions in like operator?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
What is a cursor and what are the steps need to be taken?
Oracle General 
