Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
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 to assign values to variables?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What are the different types of database objects?
what is the scenario where you take the database to NoArchivelog mode?
What is catalog in Oracle?
How many categories of data types in oracle?
What are set operators?
Why do we use bulk collect in oracle?
How to use "for" statements in oracle?
How to store pictures on to the database?
What are the restrictions in a oracle read only transaction?
How to sort the query output in oracle?
How can we create the complete backup of data in the oracle.
Explain oracle 12c new features for developers?
Explain do view contain data?