Interested to Buy Any Domain ? << Click Here >> for more details...
waht is the difference between primary key and super key?
- 9 Answers
- 31743 Views
- I also Faced
- E-Mail Answers
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
What is the difference between substr and instr?
How does Oracle guarantee data integrity of data changes?
What is an oracle user account?
What is the difference between hot backup and cold backup in oracle?
What are the restrictions in a oracle read only transaction?
Give the advantages and disadvantages of clusters.
Will you be able to store pictures in the database?explain.
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
what are the default admin accounts in Oracle 10g ?
Is there a function to split a string in plsql?
What is format trigger?
Why do you use stored procedures and state some of its disadvantages?
Will you be able to store pictures in the database?
What are the differences between primary key and unique key?
Can the query output be sorted by multiple columns in oracle?
