waht is the difference between primary key and super key?
Answer Posted / manoj jain
Primary key is subset of candidate key
primary key=not null+unique
candidate key is minimal form of super key ie. candidate key
is subset of super key
common feature:-
primary key,super key,candidate key is used to identify a
entity in relation
| Is This Answer Correct ? | 30 Yes | 4 No |
Post New Answer View All Answers
What is a system tablespace?
How do we create privileges in oracle?
How to retrieve data from an cursor to a record?
Please explain oracle data types with examples?
What is a server parameter file in oracle?
How to use "in" parameter properly?
What is a data dictionary and how can it be created?
What is the difference between truncate & delete command?
What is sequence?
How can I see all tables in oracle?
Is postgres faster than oracle?
Describe varray?
What is oracle host variable?
Calculate difference between 2 date / times in oracle sql?
How would you change old and new values in an insert, delete and update triggers?