Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210053 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
How to drop an index in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How many types of tables supported by oracle?
What is redo log?
What are the system predefined user roles?
How to create a new view in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Explain a synonym?
How do I limit the number of oracle database connections generated by weblogic server?
What is an oracle wallet?
Point out the difference between user tables and data dictionary?
How to create lov dynamically at runtime & attach to text field?
What are the various types of snapshots ?
What is a static data dictionary in oracle?
Explain the use of grant option in imp command.
