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
- 11201 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
What are the numeric comparison operations?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Difference between oracle's plus (+) notation and ansi join notation?
What is oracle thin client?
How do I find the database name in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Explain constraining triggers.
What is the usage of control file in oracle?
How to change system global area (sga) in oracle?
How to insert a new row into a table in oracle?
What are the differences between char and nchar in oracle?
What is an oracle data file?
How to write a query with a right outer join in oracle?
What is a cognitive schema?
