Interested to Buy Any Domain ? << Click Here >> for more details...
waht is the difference between primary key and super key?
- 9 Answers
- 31888 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
What is a table index?
Explain what are clusters?
How to connect to oracle using service name instead of sid?
What is the max number of columns in an oracle table?
What is recycle bin in Oracle?
What is the use of aggregate functions in oracle?
What are the differences between blob and clob in oracle?
What is ceil and floor in oracle?
What is max rowid in oracle?
How can Oracle users be audited?
Explain an index segment?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Explain the difference between sql and oracle?
What is control file used for?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
