what is unique key?
- 14 Answers
- 22889 Views
- Amazon, Cap Gemini, Infosys, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gyana ranjan behera
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we create the complete backup of data in the oracle.
What is a parameter file in oracle?
What are the parameters that we can pass through a stored procedure?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is the difference between I and G in Oracle?
6. Display the client name and order date for all orders using the traditional method.
What are the differences between blob and clob in oracle?
What is an anonymous block?
What is enter substitution variable in oracle?
Is rowid unique in oracle?
How to write a query with a right outer join in oracle?
What is analyze command used for?
How do I manually create a database in oracle?
How do I find the database name in oracle?
candidate key is subset of super key but not vice-verse explain
