What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
Answer Posted / kiran
if unique then it can have null
but if column has primary then it cannot have null values
and duplicate values
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is difference between truncate and delete?
What is a connect identifier?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to use "startup" command to start default instance?
How do I escape a reserved word in oracle?
What is integrity and what is constraint??Explain with example
What is blob datatype?
How to add another datafile to a tablespace?
How data locks are respected in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What are the different windows events activated at runtime ?
Which is better Oracle or MS SQL? Why?
How to put more than 1000 values into an oracle in clause?
How to export data with a field delimiter?
What is the dynamic sql in oracle?