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
- 10778 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 difference between count (*), count (expression), count (distinct expression)?
What is oracle open database communication (odbc)?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Can the query output be sorted by multiple columns in oracle?
What is set operator oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what are the advantages of running a database in archive log mode?
How many types of database triggers exist?
How to run create database statement again?
How do you find current date and time in oracle?
How to upsert (update or insert into a table)?
How to write numeric literals in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is connection pooling in oracle?
How to bring a tablespace offline?
