Difference between primary key and unique key ?
- 77 Answers
- 197770 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
Is a rollback possible to any savepoint?
How to create a single index for multiple columns?
How do I find the database name in oracle?
What are the original export and import utilities?
What is the fastest query method to fetch data from the table?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to bring a tablespace online?
What are the predefined tablespaces in a database?
How to execute the package in oracle?
What are the ansi data types supported in oracle?
Explain an index segment?
What are set operators?
Is oracle an open source?
What is meant by joins? List out the types of joins.
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
