Difference between primary key and unique key ?
- 77 Answers
- 191039 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 / praveen
primary key not allows null values, but unique key allows null values. only one primary is possible in one table, but multiple unique keys are possible in a table. Each unique key accepts only one null field. Both are used to prevent repeated entry of values.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is key preserved table?
How to update a table row with a record?
What the is the diff between local index and global index. give some example.
What are the components of logical database structure in oracle database?
How to insert a new row into a table in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
Explain drop constraint oracle?
What is oracle update statement with inner join ?
What is PL/SQL ?
What is set operator oracle?
How to start your 10g xe server from command line?
Explain the blob datatype?
How to insert a record into a table?
How to write a left outer join with the where clause in oracle?
what is the difference between data migration and production migration.
