Define the terms primary key foreign key and also the
difference between primary and the unique key
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 insert the image in table
What is rowid and rownum in oracle?
what is integrity constrains?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
What is Database Link ?
what is meant by magic query
What is a initialization parameter file in oracle?
What are the components of logical database structure in oracle database?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
Why cursor variables are easier to use than cursors?
What is the difference between formal parameters and actual parameters?
What is the best way to do multi-row insert in oracle?