Interested to Buy Any Domain ? << Click Here >> for more details...
waht is the difference between primary key and super key?
- 9 Answers
- 31754 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
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?
What is where clause in oracle?
What is a sub query? Describe its types?
Describe an oracle table?
What happens if the update subquery returns multiple rows?
What is merge in oracle?
Why oracle is used?
How to do a full database export?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to rename a column in an existing table?
does the query needs a hint to access a materialized view?
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 ?
How to find out what oracle odbc drivers are installed?
How to create a temporary table in oracle?
Can multiple columns be used in group by in oracle?
