Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207437 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 / mareeswaran-jeyakani
The primary key cannot be accept the null values.The unique key can accept null values. assume that you have a two
columns column1 having primary key constraint and column2 having unique constraint if u try to insert null into column2 it will accept that values whereas column1 will not accept the null values.
THANK YOU.ALL THE BEST...............
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What do database buffers contain?
what are archived logs?
How to Truncate Table in Oracle
What is oracle thin client?
Explain the use of rows option in exp command.
How to login to the server without an instance?
How to rename an existing table?
How to rebuild an index in oracle?
What happens to the current transaction if a ddl statement is executed?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Explain view?
Explain table?
What is archive log in Oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
