Difference between primary key and unique key ?
- 77 Answers
- 198095 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / mohammad ali
-The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values.
-We can declare only one primary key in a table
but a table can have multiple unique key
-Clustered index is created on Primary key constraint and
non clustered unique indexes is created on Unique key constraint.
-Primary key columns automatically become NOT NULL (unique
keys can contain nulls).
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are advantages of dateset in datastage?
How to set a transaction to be read only in oracle?
How to build data dictionary view an new database?
What is the difference between truncate & delete command?
What is the quickest way to export a table to a flat file?
What is meant by joins? List out the types of joins.
What is an index associated with a constraint?
What is connection pooling in oracle?
How do I uninstall oracle 11g?
What is PL/SQL ?
What are the differences between primary key and unique key?
What is instant client oracle?
What is the data pump export utility?
What is where clause in oracle?
