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
List out the components of logical database structure of oracle database.
various types of hints and their usage
What is rowid and rownum in oracle?
How to store only time; not date and time?
What happens to the data files if a tablespace is dropped?
What is a snapshot log?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
how to handle exceptions in post production
What are the execution control statements?
How to convert characters to numbers in oracle?
Explain what are synonyms used for?
What is recovery manager in Oracle?
Explain the use of show option in imp command.
What is user managed backup in Oracle?
How to sort the query output in oracle?