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
- 11963 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / eshwari
ur question is not clear.
if ur saying that ur giving unique and not null constraints
to the same column then u can make it as primary key.it
internally supports clustered index also.
if ur saying that ur giving unique and not null constraints
to different columns then u cant make them as primary key
individually.
coz primary key means unique + notnull + clustered index
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to empty your oracle recycle bin?
What is a relational database management system?
How can we find out the duplicate values in an oracle table?
What are data pump export and import modes?
What is the implicit cursor in oracle?
How view is different from a table?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to create a new table by selecting rows from another table?
What is a synonym? What are its various types?
What is a nested table?
What are the various constraints used in oracle?
What is a cognitive schema?
How to sort the query output in oracle?
How to shutdown your 10g xe server?
