Interested to Buy Any Domain ? << Click Here >> for more details...
If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
- 8 Answers
- 12219 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain the difference between sql and oracle?
How to get maxsal , minsal, ename department wise in single query
What is the difference between online and offline backups?
What are a query and state the different types of queries and their uses?
Explain the use of compress option in exp command.
how to make an oracle object
Explain the use of parfile option in exp command.
Does oracle partitioning improve performance?
List out the difference between commit, rollback, and savepoint?
Is a rollback possible to any savepoint?
What do you mean by redo log file mirroring?
what is the difference between data migration and production migration.
What is a trace file and how is it created in oracle?
What is recovery manager(rman) backup in Oracle?
What is instant client oracle?
