check, not null,unique

Answers were Sorted based on User's Feedback



check, not null,unique..

Answer / prasanthi

Check Constraint:

The CHECK constraint is used to limit the value range that
can be placed in a column.

not null constraint:

if we give not null constraint to any column it will not
accept null values.

Unique Conatraint:

Unique key is similar to primary key but it accepts one
null value.
For o column Setting Unique key+Not NULL we can make
Primary Key.

Is This Answer Correct ?    5 Yes 0 No

check, not null,unique..

Answer / chaitu

These are contraints

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Define indexes?

0 Answers  


what are three different authentications to connect linked servers?

1 Answers   CitiGroup,


Explain the use of containers in ssis?

0 Answers  


How to get the definition of a view out of the sql server?

0 Answers  


What is normalization of database?

0 Answers  


What is indexing?

0 Answers   AOL,


What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  


How to create a view with data from multiple tables?

0 Answers  


Explain magic tables in sql server?

0 Answers  


How does stuff differ from the replace function?

0 Answers  


Explain different types of collation sensitivity?

0 Answers  


How to copy data from one table to another table?

0 Answers  


Categories