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
State the difference between a primary key and foreign key?
Difference between the “verify” and “feedback” command?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is the simplest tool to run commands on oracle servers?
How to create a testing table in oracle?
What is the database name in oracle?
What does sharding mean?
How to rename a tablespace in oracle?
How to use "in" parameter properly?
How to drop a tablespace?
Explain index?
What is recycle bin in Oracle?
What to do if the binary spfile is wrong for the default instance?
How to convert a date to char in oracle? Give one example.
Explain what does a control file contain?