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
- 12178 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
How can we find out the current date and time in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is a directory object?
How to create a new table in oracle?
How to write a query with a right outer join in oracle?
Respected sir, Please send me technical questions related to oracle apps..
How to use "in out" parameter properly?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to use an explicit cursor without open statements?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What are operators in oracle?
Explain the characteristics of oracle dba?
What is a cognitive schema?
Explain integrity constraints?
What is data type in oracle?
