What is an Integrity Constraint ?
Integrity constraint is a rule that restricts values to a column in a table.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How will you activate/deactivate integrity constraints? 17.05.08
The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT....Why is it better to use an integrity constraint to validate data in a table than to use a stored procedure? 14.05.08
Because an integrity constraint is automatically checked while data is inserted into a table. A stored has to be specifically invoked....Why are the integrity constraints preferred to database triggers? 14.05.08
Because it is easier to define an integrity constraint than a database trigger....What is Authorization and Integrity manager? 30.06.06
It is the program module, which tests for the satisfaction of integrity constraint and checks the authority of user to access data....What is Domain-Key Normal Form? 30.06.06
A relation is said to be in DKNF if all constraints and dependencies that should hold on the the constraint can be enforced by simply enforcing the domain const...Define the “integrity rules” . 30.06.06
There are two Integrity rules. Ø Entity Integrity: States that “Primary key cannot have NULL value” Ø Referential Integrity: States that “Foreign Key...How you will set the datarelation between two columns? 14.03.06
ADO.NET provides DataRelation object to set relation between two columns.It helps to enforce the following constraints,a unique constraint, which guarantees t...What is security constraint 11.03.06
A declarative way to annotate the intended protection of Web content. A security constraint consists of a Web resource collection, an authorization constraint,...What is Authorization and Integrity manager? 11.03.06
It is the program module, which tests for the satisfaction of integrity constraint and checks the authority of user to access data....What is Authorization and Integrity manager? 11.03.06
It is the program module, which tests for the satisfaction of integrity constraint and checks the authority of user to access data. ...