If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?

Answer Posted / prashant t.

No.
It will same for doesn't allow null and duplicate values.
But, Primary key constrained applied Cluster index on that
column and unique key constraint non clustered index on
that column. that is the major differece still be there.

Is This Answer Correct ?    20 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the attributes of the cursor?

769


What are internal user account in oracle?

754


What is the difference between truncate & delete command?

872


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2005


What is the difference between primary key and unique key and foreign key in oracle?

764


What is the difference between hot backup and cold backup in oracle?

746


How to store only time; not date and time?

743


Difference between varchar and varchar2 data types?

858


What are the various types of snapshots ?

782


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1798


What is a directory object?

837


How to view existing locks on the database?

783


How to convert numbers to characters in oracle?

789


Explain oracle’s server parameter file.

756


Explain a private synonyms?

825