Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

What is a directory object?

1023


What is a sub query? Describe its types?

963


What is truncate oracle?

916


Respected sir, Please send me technical questions related to oracle apps..

1760


How to use "in out" parameter properly?

998


What is PL/SQL ?

1901


How to create a server parameter file?

1080


How to retrieve values from data fields in record variables?

1033


What are the ansi data types supported in oracle?

895


What is where clause in oracle?

981


Explain the use of control file?

1060


List the types of joins used in writing subqueries?

941


How do I limit the number of oracle database connections generated by weblogic server?

1006


What is the data type of dual table?

919


What are the uses of linked server and explain it in detail?

1001