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

ya thats true.i.e.,in case of Primary Key we can have
parent to child relationship if that is say foreign key in
another table.In case of unique and not null we cant achive
dis.

But while inserting data into one table both will have no
difference.

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of synonyms?

1138


What are joins, explain all types of joins?

2299


Can you create a synonym without having a table?

1042


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2008


What is the purpose of save points in oracle database?

1119


What is the difference between a primary key & a unique key?

1090


How to use subqueries with the in operator using oracle?

1091


Explain self joins in oracle?

1020


Explain about the analyze command in oracle?

1053


List the various oracle database objects?

1060


What is parameterized cursor in oracle?

1151


How to loop through data rows in the implicit cursor?

1074


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2287


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2187


Can you drop an index associated with a unique or primary key constraint?

1019