Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 140409 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
Answer Posted / aravindu chowdary
CONSTRAINTS:
*It is a rule (or) restriction ,which is enforced during a
creation of table.
*constraints raises automatically at the time of
inertion,updation,deletion.
*constraints there are 3 types
1.Domain Integrity
* Not null:Donot allow null value.
* check: Limits the range of values or domain, checks
the values which a col can have
2.Entity Integrity
* Unique key:donot allow duplicate values, but allows
one null per col.Can have multiple unique constraints on a
table
* Primary key : Ensure no duplicate data and not allow
nulls.
3.Refrential Intrgrity
*Forgien key:Referntial integrity b/w 2 tables, one
table col values based on other table col values
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is thr feature of change data capture?
What is attribute? : sql server analysis services, ssas
How to edit table in sql server 2017?
What are advantages of ssrs or why we should use ssrs?
Mention a few common trace flags used with sql server?
Can we join two tables without primary key?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is encryption key?
What is the difference between a clustered index and a non-clustered index?
How to make a remote connection in a database?
What is @@rowcount in sql?
How would you use user_constraints table in DB?
What is the standby server?
Explain transaction server explicit transaction?
Why should one not prefix user stored procedures with ‘sp_’?
