If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / dibya tara shakya
It will same but in case of primary key we can create the
master child relationship with other child table as foreign
key but in case of unique and not null we cannot.
another major difference is that Primary key constraint
applied Cluster index on that
column and unique key constraint non clustered index on
that column.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is hash cluster in oracle?
How to Truncate Table in Oracle
Explain an exception and its types?
Difference between inner join vs where ?
Point the difference between translate and replace?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is a user role in oracle?
How to add another datafile to a tablespace?
Explain the use of indexes option in imp command.
How to initialize variables with default values?
What is the difference between hot backup and cold backup in oracle?
How does oracle handle read consistency?
How can we create the complete backup of data in the oracle.
In oracle there is column command, how will you explain that?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));