explain the type of contraints




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

How to Run a Query on a Remote SQL Server?

2 Answers  


Which is best Subquery (or) joins in sql server? explain why

2 Answers  


how do u do Performance tunning ?

1 Answers   Satyam, Infodat Technologies,


how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,


How to retrieve data from log files in SQL SERVER ?????

1 Answers  






What is normalization?

9 Answers  


What command do we use to rename a db?

5 Answers  


I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  


Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,


1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   IBM, CarrizalSoft Technologies,


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,


i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  






Categories