Interested to Buy Any Domain ? << Click Here >> for more details...
waht is the difference between primary key and super key?
- 9 Answers
- 31639 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
How many types of auditing in Oracle?
How to use existing values in update statements using oracle?
What is Undo Management Advisor in Oracle?
What is an external table?
How to insert multiple rows with one insert statement in oracle?
How do I recompile a procedure in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Difference between pre-select and pre-query
How to create a new table in your schema?
what's query optimization and without use of IN AND Exist can we get another way data from query
Explain integrity constraints?
Is oracle an open source?
What are the differences between char and varchar2 in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
How would you best determine why your MVIEW couldnt FAST REFRESH?
