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


Please Help Members By Posting Answers For Below Questions

How to create a new user account in oracle?

792


How to load data through external tables?

878


What are the various constraints used in oracle?

798


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1870


Explain the use of show option in imp command.

847


How to resolve name conflicts between variables and columns?

809


What is columnar storage what is the advantage?

757


How translate command is different from replace?

762


Is truncate autocommit in oracle?

857


What are the different windows events activated at runtime ?

2624


Point the difference between translate and replace?

844


Explain database link?

878


Explain the difference between a procedure and a function?

835


What is ordinary table in oracle?

841


How many categories of data types?

766