Define the terms primary key foreign key and also the
difference between primary and the unique key
Answer Posted / nithya
one more difference is:
a table can have only one primary key but many unique keys.
| Is This Answer Correct ? | 22 Yes | 3 No |
Post New Answer View All Answers
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?
What are the ways tablespaces can be managed and how do they differ?
How to find out what oracle odbc drivers are installed?
What happens to the current transaction if the session is ended?
List the parts of a database trigger.
what is normalisation?what are its uses?
Whether any commands are used for months calculation? If so, what are they?
Explain an exception?
Explain enable novalidate constraint.
How to connect the oracle server as sysdba?
What is meant by a deadlock situation?
What is a cursor in oracle?
What is dynamic proxy?
What is truncate oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?