What are constraints? Explain different types of
constraints?
Answer Posted / k.swathi
constraint is a mechanism which is used to stop the data entered by the end user by implementing bussiness rules.
contraint are 6 types
1)unique
2)primary key
3)check
4)null
5)not null
6)foreign key(refferential key)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain what is the function of sql server agent windows service?
List the different index configurations possible for a table?
What do you mean by an execution plan? Why is it used? How would you view it?
Indexes are updated automatically is the full-text index also updated automatically?
What are the types of indexing?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
How can I know what locks are running on which resource?
What is normalization of database? What are its benefits?
How do I create an extended event in sql server?
What is report snapshot in ssrs?
What is the difference between sdf and mdf?
how to trace the traffic hitting a sql server? : Sql server database administration
Define model database?
What is normalization process?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do