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
- 17767 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
Compare and contrast between sql and sql server and explain its various functions?
What happens to the current transaction if a ddl statement is executed?
How to store pictures on to the database?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Why is oracle database so popular?
What do you mean by merge in oracle and how can we merge two tables?
What is the usage of synonyms?
What is user managed backup in Oracle?
Which is better Oracle or MS SQL? Why?
What happens to the current transaction if the session is ended?
Why is oracle used?
How many memory layers are in the oracle shared pool?
How to export several tables together?
What happens if recursive calls get out of control?
How to load data through external tables?
