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
What are the attributes of the cursor?
What are internal user account in oracle?
What is the difference between truncate & delete command?
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)
What is the difference between primary key and unique key and foreign key in oracle?
What is the difference between hot backup and cold backup in oracle?
How to store only time; not date and time?
Difference between varchar and varchar2 data types?
What are the various types of snapshots ?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is a directory object?
How to view existing locks on the database?
How to convert numbers to characters in oracle?
Explain oracle’s server parameter file.
Explain a private synonyms?