waht is the difference between primary key and super key?
Answer Posted / sweety singh
superkey is a set of attributes that can uniquely identify
individual tuples whereas a key or a primary key is a
minimal super key that can identify individual tuples.
ex..eno pno hrs
1 1 2
2 4 7
i.e...here eno,pno,hrs together are a superkey but eno,pno
is primary key and hence eno,pno cant hav null values and
repeated enteries....
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How to pass parameters to procedures in oracle?
How do I manually uninstall oracle client?
How to create tables for odbc connection testing?
What are the execution control statements?
What is an oracle data file?
What is ceil and floor in oracle?
Explain temporal data types in oracle
What are the major difference between truncate and delete?
What are oracle functions?
What is a nvl function?
List out the difference between commit, rollback, and savepoint?
what is reindexing?
How to shutdown your 10g xe server from command line?
How to omit columns with default values in insert statement in oracle?
How do I limit the number of oracle database connections generated by weblogic server?