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
- 10966 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
What is the use of file param in imp command?
How many data types are supported?
Differentiate between translate and replace?
How to declare a local variable?
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.
What are privileges and grants?
How remove data files before opening a database?
What is where clause in oracle?
various types of hints and their usage
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Explain view?
Explain the use of grant option in exp command.
What is the database name in oracle?
What is an oracle?
Explain self joins in oracle?
