Difference between primary key and unique key ?

Answer Posted / dj

Primary key creates Clustered Index.
Unique key creates non-clustered Index

Is This Answer Correct ?    24 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to divide query output into groups in oracle?

563


Explain an index segment?

647


Can we save images in a database and if yes, how?

594


Can multiple cursors being opened at the same time?

615


What is meant by a deadlock situation?

579






Give syntax for SQL and ORACLE joins.

636


How to store pictures on to the database?

532


What happens if you set the sga too low in oracle?

559


When do we use group by clause in a sql query?

572


How to save query output to a local file?

563


How to fetch the row which has the max value for a column?

543


What are the different types of synonyms?

603


Hi Can any one tell me what are the API's used in requisition import.

1492


What is truncate oracle?

535


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1787