Interested to Buy Any Domain ? << Click Here >> for more details...
waht is the difference between primary key and super key?
- 9 Answers
- 32004 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore singh bisht
primary key is a uniquely identified key,in primary key we use only a single attribute to identify a row.......
example:- roll no. of an student, employee id etc.
primary key=unique+not null.
and super key is a combination of two or more attributes which make the uniqueness.......
ex:-name+d.o.b+contact no...
these three attributes make the uniqueness by which we can easily identify.............
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
Can we protect our pl/sql source code?
How to pass a cursor variable to a procedure?
What is Java Pool in Oracle?
Respected sir, Please send me technical questions related to oracle apps..
How would you change old and new values in an insert, delete and update triggers?
How do I know if oracle client is installed on windows?
How to turn on or off recycle bin for the instance?
Define oracle database
How to compare dates in oracle sql?
How does one get the view definition of fixed views/tables?
types of indexes and the rationale behind choosing a particular index for a situation.
How to insert multiple rows with one insert statement in oracle?
Why is oracle used?
Difference between varchar and varchar2 data types?
How a database is related to tablespaces?
