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
Explain drop constraint oracle?
What is SQL Tuning Advisor in Oracle?
What is an oracle table?
How to delete an existing row from a table in oracle?
What are the database administrators utilities available?
How can we find out the duplicate values in an oracle table?
How to add a new column to an existing table in oracle?
Give syntax for SQL and ORACLE joins.
What privilege is needed for a user to create views in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What are the oracle differences between nvl and coalesce
How to shutdown your 10g xe server?
Is oracle an open source?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to convert a string to a date in oracle database?