waht is the difference between primary key and super key?
Answer Posted / guneetinder singh
primary key has two properties
* uniqueness.
* not null value acceptable.
where as super key is candidate key minus primary key
attributes.
| Is This Answer Correct ? | 14 Yes | 32 No |
Post New Answer View All Answers
types of indexes and the rationale behind choosing a particular index for a situation.
What are the advantages of oracle?
how to make an oracle object
Why should I use oracle database?
What is key preserved table?
What is oracle server autotrace in oracle?
What are privileges and grants?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to retrieve values from data fields in record variables?
What are the attributes that are found in a cursor?
How to start your 10g xe server?
How do I escape a reserved word in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to compare dates in oracle sql?
Which environment variables are absolutely critical in order to run the OUI?