waht is the difference between primary key and super key?
Answer Posted / nilesh
Different set of attributes which are able to identify any
row in the database is known as super key. And minimal
super key is termed as candidate key i.e. among set of
super keys one with minimum number of attributes. Primary
key could be any key which is able to identify a specific
row in database in a unique manner.
| Is This Answer Correct ? | 56 Yes | 19 No |
Post New Answer View All Answers
How to resolve name conflicts between variables and columns?
What is a select query statement in oracle?
Can we call procedure inside function in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Explain oracle left join with an example?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Is truncate autocommit in oracle?
What is a trace file and how is it created in oracle?
What is the relation of a user account and a schema?
What are the different types of trigger and explain its various uses and functions?
What is the data type of dual table?
What are dml statements in oracle?
what is the scripts in data base?
Explain how are indexes update?
What is connection pool in oracle?