Answers were Sorted based on User's Feedback
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
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
|Is This Answer Correct ?||4 Yes||0 No|
Answer / surya
Constraints are used to provide the scope to table data...
|Is This Answer Correct ?||3 Yes||0 No|
Answer / anand
foreign key constraint
|Is This Answer Correct ?||0 Yes||1 No|
Which stored procedure will you be running to add a linked server?
How do SQL server 2000 and XML linked?
Differnce between sel server 2000 and 2005
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is RAID and what are different types of RAID configurations?
What is the difference between IN and EXISTS operators in SQL Server?
What are constraints? Explain different types of constraints?
What is the use of CASCADE CONSTRAINTS?
Which command using Query Analyzer will give you the version of SQL server and operating system?
WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?
What is an execution plan? When would you use it? How would you view the execution plan?
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.