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 a data dictionary and how can it be created?
What happens to the current transaction if the session is ended?
How to rename a column in an existing table?
What privilege is needed for a user to query tables in another schema?
How to fetch the row which has the max value for a column?
What is an index associated with a constraint?
Calculate difference between 2 date / times in oracle sql?
How to turn on or off recycle bin for the session?
How to view the data files in the current database?
How do we display rows from the table without duplicates?
Explain what are the advantages of views?
Explain a data segment?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What are the logical operations?
How to create lov dynamically at runtime & attach to text field?