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
- 18064 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
How many types of tables supported by oracle?
Can we call procedure inside function in oracle?
What happens to indexes if you drop a table?
What is the difference between formal parameters and actual parameters?
How to grant create session privilege to a user in oracle?
What is SQL Tuning Advisor in Oracle?
What is the usage of control file in oracle?
What is an Oracle Instance?
What are the execution control statements in oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to get a list of all user accounts in the database?
Why we use bulk collect in oracle?
How to turn on or off recycle bin for the instance?
Difference between varchar and varchar2 data types?
How to sort output in descending order in oracle?
