Is primary key = unique key,not null? If yes,please explain IF No,please expla

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Is primary key = unique key,not null?
If yes,please explain
IF No,please explain

Question Posted / prashant pradhan

8 Answers
15314 Views
Genpact, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Is primary key = unique key,not null? If yes,please explain IF No,please explain..

Answer / arti kesharwani

No they are not equal because
we can have more than one column with not null+Unique constraints but we can have only one primary key in the table.
e.g
we can not create a table like this
create table test(id number primary key , name varchar2(10) primary key)
but we can create
create table test(id number unique not null , name varchar2(10) unique not null)

Is This Answer Correct ?

19 Yes

0 No

Is primary key = unique key,not null? If yes,please explain IF No,please explain..

Answer / anamika niit

Primary key and unique are Entity integrity constraints

Primary key allows each row in a table to be uniquely
identified and ensures that no duplicate rows exist and no
null values are entered.

Unique key constraint is used to prevent the duplication of
key values within the rows of a table and allow null
values. (In oracle, one null is not equal to another null).

Is This Answer Correct ?

16 Yes

2 No

Is primary key = unique key,not null? If yes,please explain IF No,please explain..

Answer / chanchal

a primary key can be a unique key but a unique key
may be or may not be a primary key bcoz primary key cant be
NULL but Unique Key may.
in a table more than one unique key but only one primary key

Is This Answer Correct ?

5 Yes

0 No

Is primary key = unique key,not null? If yes,please explain IF No,please explain..

Answer / kirti

Yes.When a column is assigned primary key it means it
contains unique value(i.e. no duplicate value is allowed) &
it can't accept null values.
Whereas unique key means no duplicare value is allowed, but
null value is allowed. And not null means no null value is
accepted but duplicate value can be passed.
So when we assign primary key to a column, the column
becomes both unique & not null.

Is This Answer Correct ?

2 Yes

0 No

Is primary key = unique key,not null? If yes,please explain IF No,please explain..

Answer / neeraj

No, Both are different, If we use the combination "unique+not null" the referential integrity is not maintained and that is not the case with primary key.
I think you got the difference.

Is This Answer Correct ?

3 Yes

1 No

Is primary key = unique key,not null? If yes,please explain IF No,please explain..

Answer / 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

Is primary key = unique key,not null? If yes,please explain IF No,please explain..

Answer / chandrika

if we define unique key column to not null
then first attempt it not allow to insert null value in
column but after inserting once we can edit its value to
null even if it is not null ( means its allow null)

if we assign primary key then its not allow (in every
situation it not allow null and duplication)

that is main difference between unique key and primery key

Is This Answer Correct ?

0 Yes

7 No

Is primary key = unique key,not null? If yes,please explain IF No,please explain..

Answer / dr umer saleem

We can assign a primary key as a foreign key to other tables
but we can't assign Unique Not Null as a foreign key.

Is This Answer Correct ?

2 Yes

9 No

Post New Answer