What are constraints? Explain different types of
constraints?
Answer Posted / rev
3 basic types
1.entity constraint:
check
not null
null
2.domain constraint:
unique
primary
composite primary key
3.referential constraint:
integrity
foreign
| Is This Answer Correct ? | 27 Yes | 28 No |
Post New Answer View All Answers
How to write a query with a left outer join in ms sql server?
What is table join?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Explain features of analysis services?
How to automatically create a log when an exception is being received into SQL Server?
What is federation member?
What happens if null values are involved in datetime operations?
Explain partitioned view?
Explain different types of collation sensitivity?
What are the differences between lost updates and uncommitted dependencies?
What is recompile sql server?
What is left outer join in sql server joins?
Can you always create a cache of a report?
What are diverse clauses that form a part of sql?
What is difference between rownum and row_number?