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...

what is the different between unique+not null & primary key,

Answer Posted / sreekumar

In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.

Primary key uses clustered index where are unique +Not null uses non clustered index.

Sreekumar

Is This Answer Correct ?    18 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pl sql collection?

920


What is the difference between database trigger and stored procedure?

1007


Difference between global and parameter variables?

1906


How do you declare a constant?

910


What is clause?

1064


how do you know if your mysql server is alive? : Sql dba

1025


What is the difference between subquery and correlated query?

989


Can we join same table in sql?

962


Why do we use sql constraints? Which constraints we can use while creating database in sql?

972


Explain how can you save or place your msg in a table?

981


what is the command line end user interface - mysql? : Sql dba

925


What does sql stand for?

944


What is clause in sql?

1053


Define SQL and state the differences between SQL and other conventional programming Languages?

1141


What are the two types of exceptions in pl/sql?

965