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
- 12153 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
How to convert numbers to characters in oracle?
Is it possible to split the print reviewer into more than one region ?
What are transaction isolation levels supported by oracle?
How to rename an existing table?
How to define an anonymous block?
How can I see all tables in oracle?
What is data type in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
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....
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to do a full database export?
How to select an oracle system id (sid)?
How to loop through a cursor variable?
How to export your own schema?
What is null value in oracle?
