What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
Answer Posted / allin
The Primarykey Constraint= unique + Not Null constraints.
For the Unique the meaning it self it is telling unique
value. won't accept duplicate values.
Thanks & Regards,
RatnaRao
9833847339
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the string concatenation operator in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How different is ms access and oracle?
How would you begin to troubleshoot an ORA-3113 error?
How does Oracle guarantee data integrity of data changes?
What are a collation and state the different types of collation sensitivity?
Explain about your project and its relation to the current job position you are applying to?
How to create a stored procedure in oracle?
Explain oracle left join with an example?
Give the advantages and disadvantages of clusters.
Can I create users through internet explorer in oracle 10g?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to change user password in oracle?
What is an oracle tablespace?
What is a proxy object?