Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
without using count(*) and rownum how can we count total record in a table
what are Triggers?
types of indexes and the rationale behind choosing a particular index for a situation.
What are a collation and state the different types of collation sensitivity?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
What is the use of Redo Log Information ?
What are advantages fo Stored Procedures?
What is a lookup table in oracle?
What is oracle data type?
Explain what are clusters?
Can we call procedure inside function in oracle?
What is a Data Dictionary ?