If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
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
How do I reset a sequence in oracle?
Explain the use of tables option in exp command.
interview questions with answer for cts
How to create a new oracle data file?
What is raw datatype?
How to resolve name conflicts between variables and columns?
Explain view?
Who developed oracle & when?
Is java required for oracle client?
What is SQL Tuning Advisor in Oracle?
what is the scenario where you take the database to NoArchivelog mode?
What is the difference between I and G in Oracle?
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.
Calculate difference between 2 date / times in oracle sql?
How to create a stored procedure in oracle?