Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
Answer Posted / edara satish
More or less both the keys sounds same, but the major
diffrence is where unique will allow null values, because
each null treated as a diffrent value internally. Incase of
primary key it will not allow any repeated data and null
data.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is the usage of merge statement?
How do I connect to oracle database?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Give the different types of rollback segments.
What is the difference between PFILE and SPFILE in Oracle?
Is oracle a programming language?
How do I limit the number of oracle database connections generated by weblogic server?
What is the difference between translate and replace in oracle?
Why is oracle used?
Explain what are the advantages of views?
What do you understand by a database object?
What is index-organized table in Oracle?
What is set verify off in oracle?
Which environment variables are absolutely critical in order to run the OUI?
What are the uses of linked server and explain it in detail?