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
How to pass parameters to procedures in oracle?
Give the various rollback segment states.
How to divide query output into groups in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What are the four Oracle system processes that must always be up and running for the database to be useable?
Why oracle is used?
What would you do with an in-doubt distributed transaction?
defination of bitmap index
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to test null values?
How data locks are respected in oracle?
What is system global area (sga) in oracle?
What is a snapshot log?
What is columnar storage what is the advantage?
Please explain oracle data types with examples?