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 to create a new user account in oracle?
How to load data through external tables?
What are the various constraints used in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain the use of show option in imp command.
How to resolve name conflicts between variables and columns?
What is columnar storage what is the advantage?
How translate command is different from replace?
Is truncate autocommit in oracle?
What are the different windows events activated at runtime ?
Point the difference between translate and replace?
Explain database link?
Explain the difference between a procedure and a function?
What is ordinary table in oracle?
How many categories of data types?