Integrity constraints means..? how many and what are they?

Answer Posted / xmanenter

Domain Integrity Constraint
//not null constraint this is not come
check constraint
//rule constraint (in case of SQL SERVER 2000)
//rule is an alternate to check constraint
only check because it is used as whole domain while all are
in row or tuple !

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we need distributed database?

550


What is Data Modelling?

640


What is the purpose of TNS?

664


Explain alternate key?

652


Explain the table term used in database.

577






What is the difference between database and server?

534


What are the advantages of normalizing a database.

602


Difference between sql and mysql?

1632


Can you tell any two advantages of stored procedures?

598


Which is the best graph database?

537


query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

1643


How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1489


There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?

1709


What are different types of blocks used in stored procedure?

633


What is the difference between primary and candidate key?

580