Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 88280 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rohit nanda
A constraint is a property assigned to a column or the set
of columns in a table that prevents certain types of
inconsistent data values from being placed in the columns.
There are 4 Types of Constraints.
• Entity Integrity - Primary and Unique
• Domain Integrity - Default, Check and Not Null
• Referential integrity – Foreign Key
• User-Defined Integrity - enforces some specific
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Explain database normalization?
How can you insert null values in a column while inserting the data?
What are the 10 characteristics of data quality?
How to generate random numbers with the rand() function in ms sql server?
What is the data type of time?
What is replication and database mirroring?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Do you know the isolation level that sql server support?
Mention the differences between local and global temporary tables.
What do you mean by the term 'normalization'?
Explain about Normalization?
What is an execution plan? When would you use it?
What are the differences between web role and worker role?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What to check if a User database is locked?
