Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 209901 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 / umapathy.r
The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values assume that t3 is a table with two
columns t1 having primary key constraint and t2 having
unique constraint if u try to insert null into t2 it will
accept that values whereas column t1 will not accept null
| Is This Answer Correct ? | 1164 Yes | 121 No |
Post New Answer View All Answers
What privilege is needed for a user to create views in oracle?
How do I manually create a database in oracle?
why dont we assign not null constraint as table level constraint.
What are the numeric comparison operations?
How to create a table index?
What is concurrency in oracle?
What is a trigger and what are its types?
How to synchronize 2 schema's objects?
How to view the tablespaces in the current database?
What is a nested table and how is it different from a normal table?
What is bulk load in oracle?
How to store only time; not date and time?
What is the difference between substr and instr?
What is a procedure in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
