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
- 10736 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
How to use subqueries with the exists operator in oracle?
How to export data with a field delimiter?
What's dateware house and what's clustor with practicle example
how to make an oracle object
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is the difference between $oracle_base and $oracle_home?
Explain the use of Merge statement in oracle 11g
How will you identify oracle database software release?
How to rename an existing table?
Can you have more than one content canvas view attached with a window ?
What is set verify off in oracle?
List out the types of joins.
How to connect the oracle server as sysdba?
What is the difference between I and G in Oracle?
Can we call procedure inside function in oracle?
