Interested to Buy Any Domain ? << Click Here >> for more details...
waht is the difference between primary key and super key?
- 9 Answers
- 32230 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
How to define a procedure inside another procedure?
How to create a table index?
Can you create a synonym without having a table?
How to unlock the sample user account in oracle?
Explain a segment?
What does sharding mean?
What is the fastest query method to fetch data from the table?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to use "out" parameter properly?
How to define a data field as not null?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Explain the use of control file?
How do I start tns listener?
How to use null as conditions in oracle?
what is reindexing?
