Interested to Buy Any Domain ? << Click Here >> for more details...
waht is the difference between primary key and super key?
- 9 Answers
- 31900 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 a select query statement in oracle?
Give the various rollback segment states.
Where do we use decode and case statements?
What are the differences between interval year to month and interval day to second?
does the query needs a hint to access a materialized view?
Can multiple columns be used in group by in oracle?
How to install oracle database 10g xe?
What is meant by raw datatype?
What is an oracle user role?
What happens to the current transaction if the session is killed?
How to create an oracle database manually?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is sequence?
What is set operator oracle?
Why use resource manager in Oracle?
