Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 90843 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
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
Tell me what is sql profiler?
How to start and end transact-sql statements?
what is the system function to get the current user's user id? : Sql server database administration
Explain the difference between delete,drop and truncate in SQL Server?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Do you know query execution plan?
Difference between report and query parameter.
What is order of B+tree?
What are the types of containers in ssis?
Explain “row_number()” in sql server with an example?
What the different components in replication and what is their use?
What is the difference between varchar and nvarchar datatypes?
What is @@rowcount in sql?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What are partitioned views and distributed partitioned views?
