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

How do you modify a trigger?

695


what is csv? : Sql dba

760


What is null in pl/sql?

812


Is postgresql a server?

738


Is a foreign key always unique?

681






How do you exit in sql?

815


What are the ways on commenting in a pl/sql code?

680


Is full outer join same as cross join?

697


How do we accept inputs from user during runtime?

732


What are the two types of exceptions.

828


What type of join is sql join?

721


how do you control the max size of a heap table? : Sql dba

706


How can we make an if statement within a select statement?

738


define join and explain different type of joins? : Sql dba

736


Explain the uses of control file.

780