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
- 12218 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sujith
no it is not.......... you may have some other columns which
have not null and unique constraints on it..... the thing is
that you should explicitly choose which one should be
treated as primary key so that clustered index can be put on
it, and non clustered on others where needed.........
foreign key may be used to refer to unique constraint
column, but while dropping you may loose relative unique
constraint also.. where as in case of primary referred by
foreign, will not allow so to happen............
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the different types of partitions in oracle?
What are dml statements in oracle?
What is clustered table in Oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is dynamic proxy?
Explain the use of online redo log files in oracle.
Does oracle charge for java?
What is the minimum client footprint required to connect c# to an oracle database?
How can you merge two tables in oracle?
what is the difference between data migration and production migration.
What is the difference between substr & instr functions?
How to use select statement to count the number of rows in oracle?
What is the difference between hot backup and cold backup in oracle?
How will you identify oracle database software release?
What are the ansi data types supported in oracle?
