Difference between primary key and unique key ?
Answer Posted / niranjan dhungia
Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).
| Is This Answer Correct ? | 1017 Yes | 126 No |
Post New Answer View All Answers
Can sub procedure/function be called recursively?
what are bitmap indexes? How does they work?
State any two functions of oracle?
What is Trigger in Oracle?
What are the different types of record groups in oracle? Explain each of them
Can we connect to ORACLE db using Windows Authentication?
What is the difference between Delete, Truncate and Drop in Oracle?
Please explain drop constraint oracle?
Difference between inner join vs where ?
What is an oracle tablespace?
What is proxy method?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to convert raw data type into text in oracle? Explain
What is clustered table in Oracle?
What do you understand by a database object?