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
How to end a stored procedure properly in ms sql server?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is save transaction and save point?
What structure can you implement for the database to speed up table reads?
What is the full form of ddl?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is the default server name for sql server?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is the difference between ddl,dml and dcl commands?
Explain what is the use of custom fields in report?
Explain nested trigger in sql?
What are the types of normalization?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What are user defined functions in ms sql server?