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
How to use fetch statement in a loop?
What are the types of trigger in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Explain cascading triggers.
How to create a new table in your schema?
What is the difference between substr & instr functions?
How to rollback the current transaction in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Whats the benefit of dbms_stats over analyze?
How to define a variable of a specific record type?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is a trigger and what are its types in oracle?
how to join query for one source type is oracle another source type is sql server ?
What is ceil and floor in oracle?
What is oracle analytical function?