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

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,


HOW TO RENAME A COLUMN NAME

3 Answers  


I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   IBM, HCL,


what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,


Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,






Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


What is index?

1 Answers   Cap Gemini,


What is Cross Join

3 Answers  


Explain Active/Active and Active/Passive cluster configurations?

1 Answers  


Security Question- SQL DBA exparts, need your help...

3 Answers  


Can we create a clustered index on composite primary key.

3 Answers   IGT,


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  






Categories