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 are internal user account in oracle?
What are the uses of linked server and explain it in detail?
What is a read only transaction in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What are the general rules on data consistency?
How to install oracle database 10g xe?
Write a syntax for update query in oracle?
How to get a create statement for an existing table?
What is a proxy object?
How to export several tables together?
How to list all indexes in your schema?
How to drop an existing table in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How to connect to oracle using service name instead of sid?