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
- 17698 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
Explain coalesce function?
In the oracle version 9.3.0.5.0, what does each number shows?
How do we create privileges in oracle?
What is oracle database 10g express edition?
How to update values in a table in oracle?
What is the database name in oracle?
How to define a variable of a specific record type?
What does sharding mean?
How to rename an index?
What is a tns file?
What are the differences between interval year to month and interval day to second?
WHAT IS ecc 6.0
How to empty your oracle recycle bin?
What is the difference between hot backup and cold backup in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
