what is unique key?
Answer Posted / ambresh pratap srivastava
primary key is combination of column which uniquely specify a row.A table have at most one primary key. primary key creates Clustered Index.A primary key column allows no row having null value
Unique key can uniquely identify each row in a table and is closely related to super key concept.A unique key comprises a single column or a group of column.A unique key column allows only one row having null value.Unique key creates unclustered Index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
How can you merge two tables in oracle?
what is IDE,DMV in sql server?
What is an oracle wallet?
What is logical backup in oracle?
How to write an inner join with the where clause in oracle?
What is Reduced List of Values?
What is oracle join syntax?
Give the advantages and disadvantages of clusters.
How to start your 10g xe server?
What do you mean by merge in oracle?
How to use "if" statements on multiple conditions?
Is there a combination of "like" and "in" in sql?
definition of cluster and non-clustered index?
What are a collation and state the different types of collation sensitivity?