What is the difference between UNIQUE KEY and UNIQUE INDEX?

Answer Posted / varsha

A UNIQUE Key grantees Unique values to a column but does not sort the column data, whereas A UNIQUE Index grantees Unique values to a column and also sorts the column data.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the 3 types of behavioral triggers?

666


What are the uses of merge?

721


What is the process of debugging?

555


How to check if a column is nullable before setting to nullable?

585


What is data control language (dcl)?

601






Can we use rowid as primary key?

548


what is try_catch block in procedure

1193


How does postgresql compare to "nosql"?

582


What is the starting oracle error number?

569


What is foreign key sql?

554


What is view? Can we update view

867


What are the sql aggregate functions?

612


what is 'mysqlimport'? : Sql dba

574


What is the difference between inner join and left join?

548


How many types of triggers are there in pl sql?

574