what is Constraint? How many types of constraints in SQL ?
Answer Posted / manoj kumar
Contraint is a provision to limit or enforce the data in
the sql tables. It is of five types:-
1 Primary Key Constraint
2 Foreign Key Constraint
3 Unique Constraint
4 Not Null Constraint
5 Check Constraint
Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
Explain rdbms?
When do you think a developer should use sql server-based cursors?
What are the purpose of Normalisation?
What is attribute hierarchy? : sql server analysis services, ssas
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What do you mean by an execution plan?
What is an execution plan? How would you view the execution plan?
What are the different types of join?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is nested transaction?
Why it is recommended to avoid referencing a floating point column in the where clause?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What do you understand by a view? What does the with check option clause for a view do?
How to create an index on an existing table in ms sql server?