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
What is a directory object?
What is a sub query? Describe its types?
What is truncate oracle?
Respected sir, Please send me technical questions related to oracle apps..
How to use "in out" parameter properly?
What is PL/SQL ?
How to create a server parameter file?
How to retrieve values from data fields in record variables?
What are the ansi data types supported in oracle?
What is where clause in oracle?
Explain the use of control file?
List the types of joins used in writing subqueries?
How do I limit the number of oracle database connections generated by weblogic server?
What is the data type of dual table?
What are the uses of linked server and explain it in detail?