Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNIQUE KEY and UNIQUE INDEX?
- 3 Answers
- 9050 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 1
There is a clear difference between the 2. A unique
constraint defines what combination of columns has to be
unique. A unique index is just a way of making sure the
above is always valid. But it's possible to have a non-
unique index supporting a unique constraint. (if the
constraint is deferable = Only has to be valid at commit
time but is allowed to be broken in the middle of a
transaction)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is the difference between database trigger and stored procedure?
What is coalesce in sql?
Explain the purpose of %type and %rowtype data types?
how many groups of data types? : Sql dba
What are instead of triggers?
What is posting?
Is ms sql traffic encrypted?
What are the types of join in sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
Why is a trigger used?
what are the difference between clustered and a non-clustered index? : Sql dba
What is cursor and why it is required?
Does oracle use sql?
How can get second highest salary in sql?
