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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

explain the type of contraints

Question Posted / snow obed

Answers were Sorted based on User's Feedback



explain the type of contraints..

Answer / reva ram sahu

constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.

Is This Answer Correct ?    4 Yes 0 No

explain the type of contraints..

Answer / surya

Constraints are used to provide the scope to table data...
they are..
Primary key
unique key
not null
check
foriegn key
default..

Is This Answer Correct ?    3 Yes 0 No

explain the type of contraints..

Answer / anand

primary constraint
check constraint
notnull constraint
foreign key constraint

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is the difference between set and select?

0 Answers  

What is single-user mode?

0 Answers  

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

Is foreign key unique?

0 Answers  

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

What is optimistic concurrency?

0 Answers  

What is the purpose of data source?

0 Answers  

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

0 Answers  

How to create a Master database in SQL server ?

0 Answers   MCN Solutions,

Do you know nested transaction?

0 Answers  

What are built in functions?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories