Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210429 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 / austin johnson
we can't insert a NULL value into to coloumn holding
primary key constrain.
where as we can insert a NULL value to a unique key feild.
Remember, both keys are used to identify the
rows/tuple/entry of the table uniquely.
so, only once u can enter a NULL value into the unique key
feild.
| Is This Answer Correct ? | 146 Yes | 57 No |
Post New Answer View All Answers
Explain the use of file option in exp command.
What happens to the current transaction if a ddl statement is executed?
How to create a new oracle data file?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to connect ms access to oracle servers?
what is a Nested Loop join?
Explain about your project and its relation to the current job position you are applying to?
How to invoke the original export import utilities?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to define an oracle sub procedure?
What are the different types of record groups in oracle? Explain each of them
What is analyze command used for?
What is different types of joins?
What is the best way to do multi-row insert in oracle?
Explain joins in oracle?
