Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212342 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 / mohan singh
Primary key contain non repetitive value and not null
value,and primary key is created on clustered index.In the
table their should be one primary key column.
Unique key contain non repetitive value but can contain
only one null value in the column.And unique key is created
on non clustered index.
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is a Garbage Collection? and what is full recursive Garbage collection?
How to create a table interactively?
What is oracle analytical function?
How to define a data field as not null?
What privilege is needed for a user to insert rows to tables in another schema?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Can we insert data in view oracle?
How to get maxsal , minsal, ename department wise in single query
Explain the use of Merge statement in oracle 11g
What is oracle thin client?
Why do we use coalesce function in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to connect ms access to oracle servers?
How to delete multiple rows from a table in oracle?
