Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212372 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 / omkar
In any table there can be one and only one primary key
(composite priamry key can have more than 1 column but
together conside one key only) but more than one unique
keys.
Primary key cannot accecpt null value.unique key accecpts
one or more than one null values.
primary key uniquly identifies the table but unique key is
used for uniquly identified of table as it contain one or
more than onee null.
Clustered index is created on
Primary key constraint and non clustered unique indexes is
created on Unique key constraint.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use "startup" command to start default instance?
How can I get column names from a table in oracle?
How to test null values?
What is a cognitive schema?
How to define default values for formal parameters?
How to end the current transaction in oracle?
What is oracle instant client?
What is system tablespace?
How to connect ms access to oracle servers?
What happens to the data files if a tablespace is dropped?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to convert characters to numbers in oracle?
What is execute immediate in oracle?
What is a database table in oracle?
What is the best way to do multi-row insert in oracle?
