What are constraints? Explain different types of
constraints?
Answer Posted / satyanarayana
Constraints are the constraints which can provide on the
column data.The types of constraints are
1).Domain Integrity constraints
EX:Check
2).Entity Integrity constraints
Ex:Unique,Primary key
3).Referential Integrity constraints
EX:Foreignkey
| Is This Answer Correct ? | 136 Yes | 41 No |
Post New Answer View All Answers
what is a transaction and what are acid properties? : Sql server database administration
What is optimization and its types?
What is msdb database? : SQL Server Architecture
What is sharding?
What is the new security features added in sql server 2014? : sql server security
What is the use of group by clause?
What is intellisense?
When we should use and scope of @@identity?
Can we write a distributed query and get some data which is located on other server and oracle database?
Describe the left outer join & right outer join. : sql server database administration
What is a unique index?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is use of except clause?
How does using a separate hard drive for several database objects improves performance right away?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?