A driver's salary may not exceed Rs. 25,000 p.m. This is a

Report

Report an issue

Name

Email

Message

Submit

Cancel

PGCET CSE Exam (Karnataka) 2011 click here to view all questions

A driver's salary may not exceed Rs. 25,000 p.m. This is a / an

Aintegrity constraint

Breferential constraint

Cfeasibility constraint

Dlogical constraint.

Akilesh Kharvi ? Dec 8 '2016 at 21:36

Answer : integrity constraint

Explanation:

Integrity Constraints are used to apply business rules for the database tables.
The constraints available in SQL are Foreign Key, Not Null, Unique, Check.
Check Constraint :This constraint defines a business rule on a column. All the rows must satisfy this rule. The constraint can be applied for a single column or a group of columns.

Syntax to define a Check constraint:
[CONSTRAINT constraint_name] CHECK (condition)
example: [CONSTRAINT salary] CHECK  salary<25000

All DiscussionsClick here to write answer

Answer : integrity constraint Explanation: Integrity Constraints are used to apply business rules for the database tables. The constraints available in SQL are Foreign Key, Not Null, Unique, Check. Check Constraint :This constraint defines a business rule on a column. All the rows must satisfy this rule. The constraint can be applied for a single column or a group of columns. Syntax to define a Check constraint: [CONSTRAINT constraint_name] CHECK (condition) example: [CONSTRAINT salary] CHECK salary<25000 Akilesh Kharvi ? answered Dec 8 '2016 at 21:36 All Comments

Post your answers here:

Post

Post your comments here:

Message

Post

Cancel