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
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to connect to a remote server?
What are the most common interview questions on ETL Testing for experience?
Explain what are the different type of segments?
What are the restrictions in a oracle read only transaction?
How to define and use table alias names in oracle?
What is blob data type in oracle?
Please explain oracle left join with an example?
How to call a sub procedure?
What is columnar storage what is the advantage?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
State the difference between a primary key and foreign key?
how the indexes are stored in the Oracle Database?
How to store pictures on to the database?
What is format trigger?