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?
- 7 Answers
- 10524 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raam
No. Generally Primary Key contains Unique + NotNull values.
If we are not defined a column as Primay Key and we defined
as Unique + NotNull, then, the behavior of that particular
column in that particular table looks like primary key. but
this cannot be referenced in any other table as we have not
defined as primary key..So, Primary Key column is different
from the column which have Unique + Not Null qualities.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain enable novalidate constraint.
What happens in oracle commit?
How can we delete duplicate rows in a table?
Why should I use oracle database?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is the difference between formal parameters and actual parameters?
What happens to the indexes if a table is recovered?
What is a view and how is it different from a table?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to retrieve data from an explicit cursor?
What is an oracle wallet?
What is the difference between I and G in Oracle?
What are the common oracle dba tasks?
What is the difference between a user and a schema in oracle?
What is Virtual Private Database in Oracle?
