Difference between primary key and unique key ?
Answer Posted / sikander
Primary key does not allow null value but unique key allows
null value. suppose tableA two column : columnB & columnC .
where coulmnB is primary key & columnC is unique key.
If we insert null value in columnB.It will not accept
columnB but columnC
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to define a cusotmer as a supplier in ORACLE R12
What is the difference between translate and replace in oracle?
Can we use bind variables in oracle stored procedure?
Differentiate between translate and replace?
What do you mean by a deadlock?
Explain the difference between a procedure and a function? What do you understand by those terms?
Can we save images in a database and if yes, how?
What is oracle database 10g express edition?
Can group functions be mixed with non-group selection fields?
11. Display the client number and name and the client number and name of the person who referred that client.
How to create a new oracle data file?
How to create an oracle database manually?
How to display row numbers with the records?
What is null value in oracle?
Explain the use of grant option in exp command.