waht is the difference between primary key and super key?
Answer Posted / avinash
primary key:
primary key could be any key which is able to identify
a specific row in data base in a unique manner.
super key;
different set of attributes which are able to identify
any row in the database is known as super key.
| Is This Answer Correct ? | 29 Yes | 6 No |
Post New Answer View All Answers
What is SQL Tuning Advisor in Oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is the recommended interval at which to run statspack snapshots, and why?
How to convert numbers to characters in oracle?
what is meant by magic query
Explain implicit cursor.
How can we create the complete backup of data in the oracle.
What is oracle analytical function?
How to retrieve the count of updated rows?
How to create lov dynamically at runtime & attach to text field?
How to enter a new row into a table interactively?
How to best split csv strings in oracle 9i?
Please explain joins in oracle?
How to export several tables together?