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 / eshwari

ur question is not clear.

if ur saying that ur giving unique and not null constraints
to the same column then u can make it as primary key.it
internally supports clustered index also.

if ur saying that ur giving unique and not null constraints
to different columns then u cant make them as primary key
individually.
coz primary key means unique + notnull + clustered index

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by a database object?

1051


What is the use of aggregate functions in oracle?

1021


How to login to the server without an instance?

1156


How to invoke the data pump export utility?

1175


Explain an exception?

986


What is oracle instant client?

1019


How to concatenate two text values in oracle?

1105


How to rename an index?

1063


What do you mean by a tablespace?

1033


How to delete a column in an existing table in oracle?

1065


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2615


definition of cluster and non-clustered index?

3021


How to sort output in descending order in oracle?

1034


What is a initialization parameter file in oracle?

1027


How to rollback the current transaction in oracle?

1046