Answer / upendra

Primary key creates Clustered Indexes. Clustered indexes physically sort the data.
Unique can have only Non-clustered indexes, where data are not physically sorted.

Answer / shahid

the above answer is wrong ...we can use foreign key for
unique key also...

Answer / aritra biswas

With the creation of primary key the oracle server
automatically creates and maintains a index on the primary
key column(s). Because of that index, the searching
processes on that table will be very fast where as
declaring a column as a (unique+not null) will not create
any index on that colum(s).It has to be created manually by
the DBA/users if we wish to enhance the searching process.

Answer / prativa mishra

We can create more unique key in a table but we can not create more then one primary key in a table.At the time of primary key creation thr is a clusterd index created automatically and it sorts data physically. It helps in searching process which not possible in unique+notnull column

Answer / joshy joy

1. Primary key creates Clustered Indexes and they are physically sort the data.
2. Oracle server automatically creates and maintains an index on the primary key and because of that searching will be very fast on that table.
3. Primary can be used for referential integrity when dealing with foreign key in child table

1. Unique can have only Non-clustered indexes, where data are not physically sorted.
2. unique key + not null will not create any index on that column(s)
3. Key column should be Primary key column in parent table when when dealing with foreign key

Answer / john

primary key will not allow null values.but in case of
unique,more than one null value s accepted.

Answer / banti

Both r same :)
Primary Key= (Unique + Not Null)

Answer / gazulas

if it is Primary key then we can make use foreign key in other table and can use the referential integrity concept

for unique keys we dont have that.

What is the primary key?

0 Answers  

What is rank dense_rank and partition in sql?

0 Answers  

Can you skip header records while loading? : aql loader

0 Answers  

What Is a Trigger? How Do You Use It?

3 Answers  

When to use inner join and left join?

0 Answers  

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

Give which cursor is better for better performance means type of cursors?

2 Answers  

How to return multiple rows from the stored procedure?

0 Answers  

Whis is not false in primary key?

0 Answers   Fintellix,

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

How to select all records from the table?

0 Answers