What is integrity constraints?

Answer Posted / sankar

The entity integrity constraint states that no primary key value can be null. This is because the primary key value is used to identify individual tuples in a relation . Having null value for the primary key implies that we cannot identify some tuples.This also specifies that there may not be any duplicate entries in primary key column key row.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by field in sql?

536


What is indexing in sql and its types?

545


Which command is used to call a stored procedure?

505


What is sql not null constraint?

605


What is sql profiler in oracle?

566






What are analytic functions in sql?

550


What are the types of subqueries?

573


what are the different type of sql's statements ? : Sql dba

522


What is sql and db2?

535


What does count (*) mean in sql?

1091


What are the different types of joins in sql?

583


Is sql between inclusive?

590


Why left join is used in sql?

518


What does bitemporal mean?

599


What is the purpose of primary key?

533