Interested to Buy Any Domain ? << Click Here >> for more details...
Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 18087 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between substr & instr functions?
What is literal?
How to experiment a data lock in oracle?
What operating systems are supported by oracle database 10g xe?
What is oracle used for?
What is a named program unit?
What is redo log?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
State all possible different index configurations a table can possibly have?
what are bitmap indexes? How does they work?
What is an oracle database?
What are the differences between blob and clob in oracle?
How to delete a column in an existing table?
What are the attributes that are found in a cursor?
What are the parameters that we can pass through a stored procedure?
