Difference between primary key and unique key ?
Answer Posted / anand b
Primary Key : Is an identity of a row, Only one primary key per table, No duplicate values allowed, & No NULL values are allowed.
Unique Key : Its values are unique, It can contain any number of NULL values unless combination is going to be unique.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how to join query for one source type is oracle another source type is sql server ?
How to create an initialization parameter file?
Explain the use of file option in exp command.
How to create a stored program unit?
What is oracle used for?
How to convert times to characters in oracle?
What is sequence?
Explain oracle instance.
When do I need to use a semicolon vs a slash in oracle sql?
How to convert a string to a date in oracle database?
How do I connect to oracle database?
How do we get field details of a table?
What is a nvl function? How can it be used?
what is the scenario where you take the database to NoArchivelog mode?
How can we find out the current date and time in oracle?