If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / samir kumar sahoo.
no. bcoz we can insert null values in the column which
contains the combination of constraints as
UNIQUE+ NOT NULL
but in case of primary key we can't use null values in that
primary key column
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What are internal user account in oracle?
What is the scope of a local variable?
What is merge in oracle?
How to export your own schema?
Explain about integrity constraint?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Differentiate between post-database commit and post-form commit?
What is pragma autonomous transaction in oracle?
Explain the use of rows option in exp command.
What do you understand by a database object?
What are the differences between number and binary_float in oracle?
Please explain drop constraint oracle?
Explain joins in oracle?
Is rowid unique in oracle?
Can sub procedure/function be called recursively?