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
why would you call update statistics? : Sql server database administration
Explain cursor as data base object?
when would you go for denormalization? : Sql server database administration
What is blocking?
What is sub query and its properties?
What are different types of raid levels?
What xml support does the sql server extend?
Which tcp/ip port does sql server run on? How can it be changed?
Determine when an index is appropriate?
How do clustered indexes store data?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What command do we use to rename a db, a table and a column?
What is partition in sql server?
What are secondary xml indexes?
What are parameterized reports? What are cascading parameters in ssrs reports?